Jump to content

Archived

This topic is now archived and is closed to further replies.

semtex

Need some help with a query

Recommended Posts

I have this query to do a fulltext search in MySQL, which works fine:

$sql = "SELECT ID, title ,
MATCH(title, text)
AGAINST ('" . $keywords . "' IN BOOLEAN MODE) AS score
FROM reviews
WHERE
MATCH(title, text)
AGAINST ('" . $keywords . "' IN BOOLEAN MODE)
ORDER BY score DESC";


Now I need to do the same, but it should not return rows that have these same keywords in the field "person".

So basically it has to return all the rows that have the keywords in the fields "title" or "text", but exclude the rows where the keywords are in the field "person" (as well).

Can this be done in one query?

Share this post


Link to post
Share on other sites
You can try the following
[code]
WHERE
MATCH(title, text)
AGAINST ('" . $keywords . "' IN BOOLEAN MODE)
AND NOT
MATCH
(person)
AGAINST ('" . $keywords . "' IN BOOLEAN MODE)
ORDER BY score DESC";
[/code]

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.