SELECT COUNT(*) FROM `order` WHERE `created_on` LIKE '%2020-01%'
MySQL 8 使用上面语句查询时,报以下错误。 字段 created_on 为datetime 类型
[SQL] SELECT COUNT(*) FROM `order` WHERE `created_on` LIKE '%2020-01%'
[Err] 1525 - Incorrect DATETIME value: '%2020-01%'
解决方法一:
使用函数 concat
SELECT COUNT(*) FROM `z_order` WHERE `created_on` LIKE concat('2020-01','%')
解决方法二:
SELECT * FROM `z_order` WHERE YEAR ( created_on ) = '2020' AND MONTH ( created_on ) = '01'