I have a database and i want to get dates between. my code is
SELECT * FROM `cdr`
WHERE BETWEEN calldate LIKE '2014-08-28%'
AND LIKE '2014-08-27%'
But not works...
I tried:
SELECT * FROM `cdr`
WHERE BETWEEN calldate '2014-08-28%
AND '2014-08-27'
But not worked because the column is y.m.d - h.m.s
Anyone help me ? thanks