STR_TO_DATE(json_unquote(JSON_EXTRACT(_extra, '$.createTime')) ,'%Y-%m-%d')
BETWEEN STR_TO_DATE(#{beginTime},'%Y-%m-%d') AND STR_TO_DATE(#{endTime},'%Y-%m-%d')
1.JSON_EXTRACT(_extra, ‘$.createTime’)
从_extra json字符串中获取createTime
2.json_unquote() 去掉字符串的双引号
3.STR_TO_DATE(#{beginTime},‘%Y-%m-%d’)
字符串 变 时间格式