Select from Table row from user that was recorded more than one day ago.

Select Older than 1 day rows

-- BY Kakha Giorgashvili
-- Select Older than 1 day rows

SELECT
	*
FROM
	column_name
WHERE
	USER = '1234'
AND added_time < DATE_ADD(NOW(), INTERVAL - 1 DAY)
AND added_time <> '0000-00-00 00:00:00'

Select Older than 1 day rows - SQL query

How it Works?

query is selecting row what is older than one day width code:

added_time < DATE_ADD(NOW(), INTERVAL - 1 DAY)

and this:

added_time <> '0000-00-00 00:00:00'

Web Site: WWW.ANY.GE