MySQL does not equal

[Anon]

How can I say delete all from perscriptions_temp where rp_date does not equal $date today?

This does n\'t work:

$sql_delete =mysql_query(\"delete * from perscriptions_temp where rp_date != \'$date_today\'\");

[fitzbean]

$sql_delete = mysql_query("delete * from perscriptions_temp where rp_date <> '$date_today'");

If you are using a timestamp you could also do

$sql_delete = mysql_query("delete * from perscriptions_temp where DAYOFYEAR(rp_date) <> DAYOFYEAR($date_today));

[Anon]

Thats great thanks...