marc_r Posted August 18, 2006 Share Posted August 18, 2006 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 Quote Link to comment Share on other sites More sharing options...
fenway Posted August 19, 2006 Share Posted August 19, 2006 IN BOOLEAN MODE is only available as of version 4.01. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.