Mysql 多個(gè)關(guān)鍵詞查詢，并且按照數(shù)量多少排序
文章來(lái)源地址http://www.zghlxwxcb.cn/article/200.html
直接上代碼，多個(gè)字段搜索，關(guān)鍵詞1，關(guān)鍵詞2，關(guān)鍵詞3
// 多個(gè)字段
SELECT *,
(
(IF( CONCAT_WS(" ", title, keywords, description) LIKE "%關(guān)鍵詞1%", 1, 0))
+ (IF( CONCAT_WS(" ", title, keywords, description) LIKE "%關(guān)鍵詞2%", 1, 0))
+ (IF( CONCAT_WS(" ", title, keywords, description) LIKE "%關(guān)鍵詞3%", 1, 0))
) AS sort
FROM table_name WHERE
CONCAT_WS(" ", title, keywords, description) REGEXP "關(guān)鍵詞1|關(guān)鍵詞2|關(guān)鍵詞3"
ORDER BY sort DESC
// 單個(gè)字段
SELECT
*,
(IF(title LIKE "%關(guān)鍵詞%",1,0)) AS sort
FROM
table_name
ORDER BY sort DESC
文章來(lái)源：http://www.zghlxwxcb.cn/article/200.html
到此這篇關(guān)于Mysql多個(gè)關(guān)鍵詞模糊查詢并且按照出現(xiàn)的次數(shù)多少進(jìn)行排序的文章就介紹到這了,更多相關(guān)內(nèi)容可以在右上角搜索或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
