1.left(t.`create_time`,19) AS createtime
此方式在Java里用String接收,19是截取字符串
2.DATE_FORMAT(t.create_time,'%Y-%m-%d %H:%m:%s') AS createtime
3.WHERE 1=1 AND h.`title` LIKE CONCAT('%',#{title},'%')
1.left(t.`create_time`,19) AS createtime
此方式在Java里用String接收,19是截取字符串
2.DATE_FORMAT(t.create_time,'%Y-%m-%d %H:%m:%s') AS createtime
3.WHERE 1=1 AND h.`title` LIKE CONCAT('%',#{title},'%')