[andrewgerm]

Good day all

I was wondering if there is a way to have mySQL read accents in a word as just the plain letter? I.e. if a user searches for a word with é in it, but only types e in their search, how would I find that? I don't want to assume my users will type in the correct accents. At the moment my primary search is using boolean mode.

Would all this work any better as a stored procedure? This is on a shared Internet host, so speed, and bandwidth conservation are important.

Thanks in advance for any suggestions...

[sandeep.kumar]

A couple points about Full-Text searching in MySQL:

* Searches are not case sensitive
* Short words are ignored, the default minimum length is 4 characters. You can change the min and max word length with the variables ft_min_word_len and ft_max_word_len
* Words called stopwords are ignored, you can specify your own stopwords, but default words include the, have, some - see default stopwords list.
* You can disable stopwords by setting the variable ft_stopword_file to an empty string.
* Full Text searching is only supported by the MyISAM storage engine.
* If a word is present in more than 50% of the rows it will have a weight of zero. This has advantages on large datasets, but can make testing difficult on small ones.

This link might be useful to you.

http://www.petefreitag.com/item/477.cfm

[andrewgerm]

Thanks for the reply Sandeep

The full-text searching is actually great, and I'm impressed by the speed. My only concern now, while watching a few users, was that they would have to look up the ascii code for any special characters if they wanted to search on those. These mostly pertain to people names in the database. I had been hoping they could type in something like 'e' instead of 'é' and have mySQL search on that too.

Any other tips from anyone welcome. It would be great if mySQL could handle that, so I don't have to write my own function...

[sandeep.kumar]

Try to use MySQL's SOUNDEX function.

These link might be useful to you.

http://jgeewax.wordpress.com/2006/07...ches-in-mysql/


http://www.java2s.com/Code/Oracle/Ch...OUNDEXLari.htm