Convert string to date in mysql query
Posted on 2010-11-12
I have two fields (startdate and enddate) in my table that contains a date in the format dd/mm/yyyy. The date is stored as text.
Now I want to make a query that only selects the rows where the two dates are between today and the date in the second. I have done like this, but it doesn't work:
SELECT * FROM tbl_konk WHERE `startdate` >= CURDATE() AND `enddate` < CURDATE()
The connection is up and running and works until I use the WHERE clause.
I guess I have to use some kind of conversion, but I cant figure out how.
Anyone that can help?