mysql - SQL - MATCH 显示每一行

Question

我不确定这里出了什么问题，但此查询显示了该用户的“about”和“articles”中的每个条目。我使用了随机关键字进行搜索，以确保只给出一个结果，但同样的事情发生了。

mysql_query("SELECT a.about,b.title,b.article,b.description

FROM about a 
JOIN articles b ON b.user_id=a.user_id

WHERE 

(
MATCH(a.about) AGAINST ('$search')
OR
MATCH(b.title,b.article,b.description) AGAINST ('$search')
)

AND a.user_id='$user_id'

");

SQL fiddle 问题http://sqlfiddle.com/#!2/e963d/1

Answer 1

mysql_query("SELECT DISTINCT a.about,b.title,b.article,b.description

FROM about a 
JOIN articles b ON b.user_id=a.user_id

WHERE 

(
MATCH(a.about) AGAINST ('+$search' IN BOOLEAN MODE)
OR
MATCH(b.title,b.article,b.description) AGAINST ('+$search' IN BOOLEAN MODE)
)

AND a.user_id='$user_id'

");

This article可以为您提供有关以不同方式使用 MATCH 的更多信息

在“about”和“title-article-description”中单独搜索

SELECT a.about,null title,null article ,null description

FROM about a 

WHERE 

(
MATCH(a.about) AGAINST ('BNMV' IN BOOLEAN MODE)
)

AND a.user_id='1'

UNION
select null, b.title,b.article,b.description
from articles b 

where 
(MATCH(b.title,b.article,b.description) AGAINST ('BNMV' IN BOOLEAN MODE))
AND b.user_id='1'