Full text search question
 

Gidday

When I use the full text boolean search on, eg, 'Y M C A', it gets ignored due to the min word size setting (which I have set on two letters so a word like 'U2' can be found).

Apart from storing records such as Y M C A as YMCA, is there a way to get full text search to work when the keyword is a group of initials?

I first thought about concatenating groups of initials in php, but that seems messy and would result in lots false hits.

Any solutions to this in mysql?

Thanks for taking a look.