Mysql to figure out yesterday

ok, i got a lil select statement that wont work, any ideas what to do here:

SELECT email
FROM `1717avenue`
WHERE `date` = [COLOR=Red](yesterday)[/COLOR]

the “(yesterday)” thing needs to actually be yesterdays date, its also in an actual “date” column in mysql. I would try like crazy and “try” to get some useful information off the mysql site, but well, im really busy:D

Anybody with a quick answer, help me out.