# Mysql to figure out yesterday

**URL:** <https://forum.kirupa.com/t/mysql-to-figure-out-yesterday/235650>\
**Category:** Uncategorized\
**Created:** [August 13, 2007, 6:44pm UTC](https://forum.kirupa.com/t/mysql-to-figure-out-yesterday/235650 "2007-08-13T18:44:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\
**Post date:** [August 13, 2007, 6:44pm UTC](https://forum.kirupa.com/t/mysql-to-figure-out-yesterday/235650/1 "2007-08-13T18:44:24Z")

</div>

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

```auto
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.