Hello All, If i use full text search with Boolean mode i got the following error
mysql> select * from articles where match (title,body) against('+Your -Trail' in boolean mode); ERROR 1064: You have an error in your SQL syntax near 'boolean mode)' at line 1 How can i over come this error. mysql> select * from articles where match (title,body) against('+Your -Trail'); If i use above query it is retreving data at manually. if i run the quey through PHP it is not retreiving any data. Let me know how can I solve these two problems. regards, sreedhar [EMAIL PROTECTED] --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php