网上看了教程,自己编写了一段全文检索, ORDER BY relevance的代码,但是搜索结果横竖为0,到底哪里有问题?我想要:关键字70%符合字段名title,content,30%符合字段名tags。即字段名title,content优先于字段名tags。谢谢。
SELECT *,
(
(job='worker' AND
MATCH (title,content) AGAINST ('+$boolean' IN BOOLEAN MODE)* 0.7)
+
(job='worker' AND
MATCH (tags) AGAINST ('+$boolean' IN BOOLEAN MODE) * 0.3)
)
AS relevance
FROM worker_table
WHERE match (title,content,tags) AGAINST ('+$boolean' IN BOOLEAN MODE)
AND job='worker'
ORDER BY relevance DESC
SELECT *,
(
(job='worker' AND
MATCH (title,content) AGAINST ('+$boolean' IN BOOLEAN MODE)* 0.7)
+
(job='worker' AND
MATCH (tags) AGAINST ('+$boolean' IN BOOLEAN MODE) * 0.3)
)
AS relevance
FROM worker_table
WHERE match (title,content,tags) AGAINST ('+$boolean' IN BOOLEAN MODE)
AND job='worker'
ORDER BY relevance DESC
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货