Full text search not matching 2 letter word

Im trying to run a full text query on a two letter keyword 'K7'. I have set ft_min_word_len=2 and restarted the server and if I view the system vars in Mysql Workbench it shows it is set correctly. I have then dropped and re-created the index on the descrip column. It is an InnoDB table so I c

Self Join Performance

Hello everyone! I've got a few questions regarding optimizing self-joins. So I've got these three tables: mysql> describe FieldName; +-++--+-+-++ | Field | Type | Null | Key | Default | Extra | +-+--