Need some help with a query

[semtex]

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?

[shoz]

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]