Short words vs. MySQL Fulltext Index

Need to match on 3-letter words

[timster]

I've got a little PHP/MySQL cookbook that uses fulltext index "keyword" searches, served by on a "cpanel" commercial Web host.

Unfortunately 3-letter words aren't included in MySQL FTI, by default. That leaves out some pretty important cooking words, such as "egg," "fat," and "rum."

It'd be an easy fix if the MySQL server were mine. Is there still a way, or shall I just refer 3-letter words to the LIKE statement?

[coopster]

I've tried other ways, like trying to "fool" the server with wildcard statements like MATCH (column) AGAINST ('egg*') but get unexpected results, and often no results. Without access to the

ft_*

Server System Variables [dev.mysql.com], you are probably best off going with the

LIKE

keyword. If you are running on a *nix box, have you asked the host if you can set a user-specific option file [dev.mysql.com]?

[timster]

Thanks, coopster.

Yes, it's hosted on Linux, so I'll ask the host about the options file.