MySQL Forums
Forum List  »  Full-Text Search

Re: Problem with MySQL Full-Text Search
Posted by: Rick James
Date: July 31, 2012 06:56PM

SELECT * FROM patients WHERE MATCH(full_name) AGAINST('jassim ali' IN BOOLEAN MODE) ORDER BY full_name;

"ali" will not match because of
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_ft_min_word_len

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Problem with MySQL Full-Text Search
1990
July 31, 2012 06:56PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.