Jump to content

Archived

This topic is now archived and is closed to further replies.

marc_r

In Boolean Mode problem

Recommended Posts

I have the following query:

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

and gives me this error:

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

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

Share this post


Link to post
Share on other sites
IN BOOLEAN MODE is only available as of version 4.01.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.