Hi

How do I overwrite the "ft_min_word_len" variable if I don't have access to any ini files? I've looked on the MySQL site for documentation and it seems to be written for people that maybe host their own site that have full access to everything?

I've got quite a few keywords in a database that are 3 letters long like cat and fur. But they don't get found at the moment because ft_min_word_len is set as the defualt 4.

Is there a way I can change this from phpMyAdmin or in a PHP script/command that would overwrite SQL variables? A bit like ini_set()

Thanks

Kevin

I'm guessing this problem is due to your searches being full text searches. You could easily modify your code to account for 3 or less characters by using a like search rather than full text.

Originally Posted by cptnwinky

I'm guessing this problem is due to your searches being full text searches. You could easily modify your code to account for 3 or less characters by using a like search rather than full text.

Cheers I'll give it a try tomorrow, and they are currently full text searches. LIKE won't work with multi keyword searches though will it?

Yep, just create a single string with all the keywords.