这是我能够得到2018-12-12日期数据的代码。

SELECT COUNT(`table`.`ID`), `table`.`number_Of_Car`
FROM `company`.`table` 
WHERE `table`.`location` <> '' AND `table`.`location` LIKE('%2017-12-12%') 
Group by ...

不过，我尝试了以下方法：

SELECT COUNT(`table`.`ID`), `table`.`number_Of_Car`
FROM `company`.`table` 
WHERE `table`.`location` <> '' AND `table`.`location` BETWEEN('%2018-12-12%') AND ('%2018-12-13%') 
Group by ...

有没有办法让我做以下工作？