[RESOLVED] mysql query question

[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?

[semtex]

for those who care, I used "AND NOT MATCH"
it worked fine.