Richard Rodriguez Richard Rodriguez - 10 months ago 40
MySQL Question

MySQL select yesterday's date

If I have a date like this:


And I want to write a MySQL query with
is "yesterday", how do I do it?


A simple way to get yesterday's date is to use subdate() function:

subdate(currentDate, 1)