Full text indexing
Posted: Mon Dec 04, 2006 6:01 am
Hi I am attempting a full text index, though I am experiencing the following error:
"You have an error in your SQL syntax near 'BOOLEAN MODE)' at line 1"
my code is as folllows:
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
"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