Help with statement to select row where dates previous to today.

[Robbiez]

HI

Can anyone help with a statement to select all rows from a table where the value of a column is earlier than today's date.
The date is stored as(for example) Monday 1 March %W %e %M

I was hoping something like this would work:

SELECT * FROM `table` WHERE DATE_FORMAT(dispatchdate, '%W %e %M') < NOW()-INTERVAL 1 DAY

Thanks

[requinix]

16 minutes ago, Robbiez said:

The date is stored as(for example) Monday 1 March

Well there's your first problem. Store it as an actual DATE and format it when you display the value to the user, then working with it in your SQL will be much easier - and faster, more efficient, using fewer system resources, etc.