Mysql Config File Not Accessible

[frankieJr]

Hii have a database running on HostMonster Server... the problem is that they do not allow customers to change settings.they say "The my.cnf file for the server is not accessible" .. basically wat i need to do is to change the min number of characters in search .. ft_min_word_len = 4 is the default, now since i cant do anything about that , how can i solve the problem in other ways... ?

[Synook]

You can check for a certain number of characters in a MySQL query using the CHAR_LENGTH() function.

SELECT * FROM search_table WHERE CHAR_LENGTH(search_field) >= 4