Selecting DATA which is submitted 1 day before(yesterday)

[darubillah]

 

Hello,

 

I am trying to fetch data which is one day old,

 

I used now() function to insert current date,

 

What could be the query??

 

<?
//This query will select the data which is submitted today.
$sql="SELECT * FROM table_name WHERE date=". now();
?>

 

so what will be the query to fetch yesterday's records, should be some thing done with now() function

 

Thankyou

[gristoi]

try:

$sql="SELECT * FROM table_name WHERE date(date)=DATE_SUB(CURDATE(), INTERVAL 1 DAY);