Fecha del día anterior - mysql. -- :s

[huesos52]

Código MySQL:

mysql> select now();
+---------------------+
| now()               |
+---------------------+
| 2010-02-26 15:13:37 |
+---------------------+
1 row in set (0.02 sec)
 
mysql> select date_sub(now(),interval 1 day);
+--------------------------------+
| date_sub(now(),interval 1 day) |
+--------------------------------+
| 2010-02-25 15:13:48            |
+--------------------------------+
1 row in set (0.00 sec)
 
mysql>
 

saludos