查询两个日期之间的Mysql无法正常工作

Question

I have a table that contain two datetime field. So when I going to search anything betwwn two dates then it do not show exact result. It suffering me more when I want to see only one day search result. My code is

SELECT * FROM item WHERE production_date BETWEEN $a AND $b

Answer 1

You are using datetime as the type for your field. Change it to only date and it will works fine!

Or you can use '2014-05-27 00:00:00' as start date and '2014-05-28 23:59:59' as your end date. Means add some extra string with your variable.