How to compare date in MySQL query

[ketting00]

Hi,

I have

 $date = date("Y-m-d");

How do I get date comparison in MySQL query that looks something like this:

SELECT expired_date
FROM subscription
WHERE expired_date > '$date'

Thanks