I get complaints from my users that they can't search on three letter words like "eye". For years I was under the assumption that it's impossible with mySQL. Today I decided that I better ask the experts to see if I'm wrong. Here is the current query that I have in place. Please advise.


SELECT tID, date_format(date, '%m-%d-%Y') as date, viewed, summary, MATCH (summary,testimony,keywords) AGAINST ('$q') AS score FROM testimonies WHERE MATCH (summary,testimony,keywords) AGAINST ('$q') and approved = 'Yes' order by score desc limit 50