Full text search question
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.