Full text indexing

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
hame22
Forum Contributor
Posts: 214
Joined: Wed May 11, 2005 5:50 am

Full text indexing

Post 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
Corvin
Forum Commoner
Posts: 49
Joined: Sun Dec 03, 2006 1:04 pm

Post 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
hame22
Forum Contributor
Posts: 214
Joined: Wed May 11, 2005 5:50 am

Post by hame22 »

cool, but is there a solution while in mysql 3?

thanks again
Post Reply