I want to return the lines in which there is no word 'b'.

SELECT * FROM `login` WHERE MATCH(`author`) AGAINST('param -b' IN BOOLEAN MODE)"

Returns

 Array ( [author] => param a ) Array ( [author] => param a ) Array ( [author] => param b ) Array ( [author] => param )

The Myisam table is used, the FULLTEXT index is FULLTEXT on the column.

    1 answer 1

    As I understood from everyones doc - 'b' too short to be a word, is determined by setting ft_min_word_len