MYSQL query data method by time period (example description) _php tips

Time format for 2008-06-16
Check out the Day data:
SELECT * from ' table ' WHERE date (time field) = Curdate ();
Query out the Month field:
SELECT *
From ' table '
WHERE Month (time field) = Month (now ());
Time format is 1219876 ... Unix time, as long as the "from_unixtime ()" function is applied
For example, check the month:
SELECT *
From ' table '
WHERE month (From_unixtime (reg_time)) = month (now ());
What about the one-month query? Be flexible!
SELECT *
From ' table '
WHERE month (From_unixtime (reg_time)) = month (now ())-1;
It's so simple and complicated to add later!