How to select entries less than 24 hours old in MySQL

To select entries less than 24 hours old in MySQL you can use the following snippet.

Sample MySQL

SELECT * FROM TABLENAME WHERE COLUMNNAME >= DATE_SUB(Now(),INTERVAL 24 HOUR)

Please Share us:
Please rate this snippet

One thought on “How to select entries less than 24 hours old in MySQL

Leave a Reply