How to get all record of yesterday from table in mysql?

How to get all record of yesterday from table in mysql? if you are looking for sql query which will return you all record of yesterday. So please take a look on this query and replace the content according to your table Let your table is like this: So your query will be like this select id from tbl_download WHERE date(download_date) = ADDDATE(current_date,-1) Happy coding :)