CODEWITHSUNDEEP
phpmysql
Elgoog
Elgoog

Reputation: 2275

mysql query for all records not today

How would I return all rows that are not from today? Im running a query on results returned from this. each row has a mysql timestamp. thanks.

Upvotes: 3

Views: 6337

Answers (2)

genesis
genesis

Reputation: 50982

select something from table where DATE(unix_time) <> DATE(NOW())

<> does mean != (does not equal)

Upvotes: 0

Amber
Amber

Reputation: 527548

select * from your_table where DATE(timestamp_field) <> DATE(NOW())

Upvotes: 10

Related Questions