deleting rows where date <= today

[richardhowell]

My hosting service is running a version of MySQL prior to implementation of subqueries. This makes it more difficult for me to do a query which will delete rows from a table where dt_start <= today's date, as I can't select CURRDATE() in the subquery. What's the 2nd best way of doing this?

 

[QatQat]

delete from table where date <= curdate()


What is the need for subqueries?


Bye

Qatqat

Life is what happens when you are making other plans.

 

[richardhowell]

Damn! I had tried that initially and it was giving me an error. But being new to MySQL I hadn't noticed CURDATE has only one 'R'
Thanks - (with blushes)

 

[QatQat]

Cool, not a problem.


Bye

Qatqat

Life is what happens when you are making other plans.