datetime字段不允许仅使用MySQL和PHP来搜索日期

Question

My MySQL table has START_DATE(datetime). The value stores in this field like 2014-02-05 12:50:16.

Now I have tried SELECT * FROM table WHERE START_DATE= '2014-02-05'. It returns empty value. So, Please help me to SELECT values by date.

Thanks in advance.

Answer 1

use Date function on the datetime field to compare.

SELECT * FROM table WHERE Date(START_DATE)= '2014-02-05'.