Hopefully a quick one. I want to select rows where the date is 1 days prior to the current day.
Trouble is the date is stored in a UK format as text (i.e. 17/06/2013). Is this possible?
so far I have this which obviously wont work:
SELECT * FROM surveys WHERE date < CURRENT_TIMESTAMP - INTERVAL 1 DAY