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 :)
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:
select id from tbl_download WHERE date(download_date) = ADDDATE(current_date,-1)
Happy coding :)
Comments
Post a Comment