mysql - Syntax error when using parentheses with BETWEEN -


i thought following way search calls placed in 10 minute time frame

select * `call_log` start_time between ('2012-05-01 17:50:00' , '2013-05-01 18:00:00') 

however when run query following error

#1064 - have error in sql syntax; check manual corresponds mysql server version right syntax use near 'limit 0, 30' @ line 2 

i not sure means, , wondering if me. date formate same above too.y-m-d h:m:s

you don't need parentheses:

select * `call_log`   start_time between '2012-05-01 17:50:00' , '2013-05-01 18:00:00' 

Comments