开发者

3 characters search on a shared hosting mysql

开发者 https://www.devze.com 2023-03-25 02:45 出处:网络
I need to do a 3 chars search with mysql. On a dedicated server, I\'d change ft_开发者_Go百科min_word_len=3 on the my.cnf file.

I need to do a 3 chars search with mysql.

On a dedicated server, I'd change ft_开发者_Go百科min_word_len=3 on the my.cnf file.

Is there a workaround to do this on a shared host?

Thanks!


If you can't access the config yourself, ask nicely. Some hosters are going to provide you with an alternative. Otherwise, you could use LIKE. Not a full substitute, but a workaround:

SELECT * FROM t1 WHERE searchcol LIKE '%abc%'
0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号