"You have an error in your SQL syntax near 'BOOLEAN MODE)' at line 1"
my code is as folllows:
Code: Select all
$result = mysql_query("SELECT * FROM news WHERE MATCH (news_headline,news_body) AGAINST ('-redtray' IN BOOLEAN MODE)") or die(mysql_error());I would appreciate it if someone could tell me my errors
I am using version 3.2.8 of mysql is boolean mode supported in this?
thanks in advance