小弟写了个sql，要吐血了

union 分页

SELECT title,description,name from wp_content  WHERE
( title LIKE CONCAT('%',#{keyWordsLike},'%') or description LIKE CONCAT('%',#{keyWordsLike},'%') or `name` LIKE CONCAT('%',#{keyWordsLike},'%')) and is_show =1 and deleted =0
UNION
(SELECT title,description,name  from wp_biz_product  WHERE
(title LIKE CONCAT('%',#{keyWordsLike},'%') or description LIKE CONCAT('%',#{keyWordsLike},'%') or `name` LIKE CONCAT('%',#{keyWordsLike},'%')) and is_show =1 and deleted =0 ORDER BY rank ) limit #{start},#{end}

直接就这么写了

优化后的sql

SELECT  title,description,name from  (SELECT title,description,name from wp_content  WHERE
( title LIKE CONCAT('%',#{keyWordsLike},

文章来源: blog.csdn.net，作者：隔壁老瓦，版权归原作者所有，如需转载，请联系作者。

原文链接：blog.csdn.net/wxb880114/article/details/108472435