3

This is not really a question but I was struggling to match two letter words using MATCH AGAINST and other people might find this useful.
MySQL is configured to take only words with a minimum length of 4 as part of a fulllength search (thats why MATCH AGAINST doesnt work with "AA" but LIKE does).
Anyway... to get around this, go into /etc/mysql/conf.d and create a file with extension .cnf (e.g. user_sett.cnf) include in
line 1: [mysqld]
in line 2: ft_min_word_len = 2
and save. Restart the server by rebooting the appliance and that should do it.

1
  • Afraid this kind of posts is not suitable for this particular community! Perhaps try the Facebook group, or the sub-reddit!
    – kzidane
    Commented Dec 18, 2016 at 20:44

0

Browse other questions tagged .