WHERE("title like '%'+#{keyWord}+'%'"); -MS SQL
WHERE("title like concat('%',#{keyWord},'%')"); -MySQL
WHERE("title like '%'+#{keyWord}+'%'"); -MS SQL
WHERE("title like concat('%',#{keyWord},'%')"); -MySQL
转载于:https://www.cnblogs.com/zhuxiang1633/p/8967696.html