hello,
hope you can help, would like to change the following line
WHERE MATCH (artists.artist) AGAINST ('$id')
to
WHERE DOESN'T MATCH (artists.artist) AGAINST ('$id')
ie i would like to show all results where $id does not occure
Thank you
Gareth
Not sure if this is valid, but it's worth a try:
WHERE NOT MATCH ...
I do believe NOT MATCH is valid, or you can just use the '-' negation character:
- A leading minus sign indicates that this word must not be present in any of the rows that are returned. Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.”
-
A leading minus sign indicates that this word must not be present in any of the rows that are returned.
Note: The - operator acts only to exclude rows that are otherwise matched by other search terms. Thus, a boolean-mode search that contains only terms preceded by - returns an empty result. It does not return “all rows except those containing any of the excluded terms.”
For more info, see this link.
