frankieJr Posted September 28, 2009 Share Posted September 28, 2009 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... ? Link to comment Share on other sites More sharing options...
Synook Posted September 29, 2009 Share Posted September 29, 2009 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.