I have this query to do a fulltext search in MySQL, which works fine:
$sql = "SELECT ID, title ,
AGAINST ('" . $keywords . "' IN BOOLEAN MODE) AS score
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?
Need some help with a query
1 reply to this topic
0 user(s) are reading this topic
0 members, 0 guests, 0 anonymous users