WHERE datetime older than some time (eg. 15 minutes)

by

older would be WHERE creation_date < DATE_SUB(NOW(),INTERVAL 15 MINUTE)

More Related Contents:

  1. MySQL – Get row number on select
  2. How to use GROUP_CONCAT in a CONCAT in MySQL
  3. MySQL query / clause execution order
  4. How can I tell when a MySQL table was last updated?
  5. Operand Should Contain 1 Column – MySQL NOT IN
  6. Error Code: 1005. Can’t create table ‘…’ (errno: 150)
  7. MySQL: Error Code: 1118 Row size too large (> 8126). Changing some columns to TEXT or BLOB
  8. On duplicate key ignore? [duplicate]
  9. What’s the difference between comma separated joins and join on syntax in MySQL? [duplicate]
  10. List of Stored Procedures/Functions Mysql Command Line
  11. mySQL longitude and latitude query for other rows within x mile radius
  12. How to design a multi tenant mysql database
  13. How to get the count of each distinct value in a column? [duplicate]
  14. Get results that fall within marker radiuses from database
  15. Bash script to insert values in MySQL
  16. MySQL dynamic cross tab
  17. SELECT INTO and “Undeclared variable” error
  18. How to disable index in innodb
  19. How do I lag columns in MySQL?
  20. How to get multiple records against one record based on relation?
  21. SQL query to check if a name begins and ends with a vowel
  22. What is the best way to store media files on a database?
  23. SQL: deleting tables with prefix
  24. How to use a user variables in MySQL LIKE clause?
  25. INNER JOIN Results from Select Statement using Doctrine QueryBuilder
  26. MySQL DROP all tables, ignoring foreign keys
  27. MySQL: Check if the user exists and drop it
  28. Get the second highest value in a MySQL table
  29. Retrieving only a fixed number of rows in MySQL
  30. Speeding up mysql dumps and imports [closed]

Leave a Comment