i am trying to select from a table with the condition of date=yesterday's date

any function in php or mysql which returns a date before today?