mybatis模糊查询

mysql数据库

select * from table_name where create_time like concat(#{createTime},'%');

select * from table_name where create_time like concat('%',#{createTime},'%');

select * from table_name where create_time like "%${createTime}%";

select * from table_name where create_time like "${createTime}%";

and DATE(t.create_time) BETWEEN #{startTime} AND #{endTime}