Jump to content


Photo

In Boolean Mode problem


  • Please log in to reply
1 reply to this topic

#1 marc_r

marc_r
  • New Members
  • Pip
  • Newbie
  • 3 posts

Posted 18 August 2006 - 11:14 PM

I have the following query:

"SELECT * FROM products WHERE MATCH(Product_No, Title, Category) AGAINST ('$keyword*' in boolean mode)";

and gives me this error:

#1064 - You have an error in your SQL syntax near 'boolean mode )

The query was working fine on my local server but once i migrated it to the new remote server it wont let me run this. I've also tried the query w/o 'in boolean mode' and it works just fine.. anyone have any ideas please?? thanks!

marc



#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 19 August 2006 - 01:15 AM

IN BOOLEAN MODE is only available as of version 4.01.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users