mysql now() question 1

[TGJ]

I would like to know how i can manipulate the now() command to make it actually mean yesterday.

basically I need now() - 1day

Is there some way I can achieve this? perhaps now() is not the proper function to use, any help is much appreciated.

 

[TonyGroves]

You could use:[tt] NOW() - INTERVAL 1 DAY[/tt]

NOW() returns the current date and time. To get the current date, you can use CURDATE() .

 

[TGJ]

Cool, thanks.