MySQL Forums
Forum List  »  Full-Text Search

can't find partial words
Posted by: Viktor B
Date: July 27, 2005 09:35AM

I have found that my queries won't return any results if searching for a partial words

example: the fname field contains full name "Larry Wright"
no results are returned if searched for "Larr" or "Wrigh"
right now it's returning resuls when searched for a full word "Larry" or "Wright" or "Larry Wright"
this used to work before, what could happend ? I need to find the record by any part of the name
P.S.
ft_min_word_len = 3



SELECT fname
FROM notices
WHERE MATCH (fname) AGAINST ('ALBRECHT')
ORDER BY fname



Edited 1 time(s). Last edit at 07/27/2005 10:07AM by Viktor B.

Options: ReplyQuote


Subject
Views
Written By
Posted
can't find partial words
3150
July 27, 2005 09:35AM
2121
December 19, 2005 08:55AM


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.