Skip to content

Instantly share code, notes, and snippets.

@jimmy89Li

jimmy89Li/selectUpdatedLastHour.sql

Created May 10, 2017 09:11
Show Gist options
  • Save jimmy89Li/c31ca92c8fb3c515f519a56229ce667d to your computer and use it in GitHub Desktop.
Save jimmy89Li/c31ca92c8fb3c515f519a56229ce667d to your computer and use it in GitHub Desktop.
Download ZIP
Select from database where updatedDate was done in the last 60 minutes
Raw
selectUpdatedLastHour.sql
SELECT * FROM wp_terms WHERE updatedDate > (now() - interval 60 minute);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment