Page 1 of 1

Full text indexing

Posted: Mon Dec 04, 2006 6:01 am
by hame22
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:

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

Posted: Mon Dec 04, 2006 9:00 am
by Corvin
http://dev.mysql.com/doc/refman/4.1/en/ ... olean.html
As of version 4.0.1, MySQL can perform boolean full-text searches using the IN BOOLEAN MODE modifier
You should update your MySQL anyway. :D

Posted: Mon Dec 04, 2006 9:13 am
by hame22
cool, but is there a solution while in mysql 3?

thanks again