mysql 日期转字符串查询，int 匹配字符串查询

1.MySQL查询日期（datetime）类型转字符串

select DATE_FORMAT(CREATE_TIME,'%Y-%m-%d %H:%i:%s') as CREATE_TIME from 表名;

2.类型为int，前端输入字符串查询。把int匹配字符串再查询

SELECT a.* FROM (SELECT *, (CASE checkederStatus WHEN 0 THEN '未盘点' WHEN 1 THEN '盘点中' WHEN 2 THEN '盘点完毕' ELSE '' END) AS checkederStatusStr FROM srcb_checkclass) AS a 
WHERE checkederStatusStr LIKE concat('%', '未盘点', '%'))