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 Link to comment https://forums.phpfreaks.com/topic/17994-in-boolean-mode-problem/ 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. Link to comment https://forums.phpfreaks.com/topic/17994-in-boolean-mode-problem/#findComment-77085 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.