compare date

[nuttynibbles]

mysql table, i have a field of 'date' type which store date in yyyy-mm-dd
in my php scipt, i wanna compare it with a string also in yyyy-mm-dd..
how do i do tat.

[devinemke]

SELECT * FROM table WHERE date = '$date'

where $date is your date string