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 ):
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!
Selecting records added between two different dates
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users