MySQL Forums
Forum List  »  Full-Text Search

Matching with Periods
Posted by: Matthew Andersen
Date: October 07, 2008 04:13PM

So fairly new to Fulltext indexes. Everything is working fairly well, however I am trying to figure out how to get a certain search to match.

I have entries in the database that are indexed as follows (a couple examples)
The O.C.
W.I.T.C.H.

I want the end user to be able to search on The OC or OC and return The O.C. Or have them search on Witch and return W.I.T.C.H.

This is a small index, there are only 14k rows. I have set my ft_min_length=1 and ft_stopword_file=

For the time being as I am doing testing. Anyone have any ideas?

Thanks,
Matthew

Options: ReplyQuote


Subject
Views
Written By
Posted
Matching with Periods
4225
October 07, 2008 04:13PM


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.