MySQL queries the day before data

How does the MySQL database query data for the previous day based on time? This article has sorted out several solutions that are needed by a friend under reference.

The content of this section:
How to use MySQL to query the data of the previous day based on time.

Example 1:

code Example:SELECT * FROM TT where F1=DATE_ADD (today (), INTERVAL-1 Day)

Example 2:

code Example:SELECT * from the TT where F1 between Date_sub (Curdate (), INTERVAL 1 day) and current_date ();

Example 3,mysql time query.

code Example:SELECT * FROM TT
Where F1 >= date_sub (Curdate (), INTERVAL 1 day)
and F1 < Current_date ();

Example 4,mysql time query.

code Example:SELECT * FROM Tig_users
where date (Last_login) =curdate ()-interval 1 DaySelect Date_sub (now (), Interval 1 day);Adddate (now (),-1) can also achieve the effect

MySQL queries the day before data