Selecting records added between two different dates

[nezbie]

Hi

I'd need an example of a query how to SELECT data between two given dates in mysql, I need it for my search function..

I think I'd need to somehow make sql convert given dates to different format than regular date (LIKE 2006-06-05)..

So basicly something like this my query would be (english good, me Ralph :D):

SELECT id FROM lists WHERE list_date_added BETWEEN 2006-06-01 AND 2006-06-06

That doesn't ofcourse work, it's like I told SQL to SEE if an elephant is more than 3..

Any help with this is appreciated greatly, thank you in advance!

[fenway]

Should be fine -- just add quotes around your date to make them proper string literals.