Hi, I have tried:
select title from table where match(title, body) against('IT' in boolean mode); The result was 0 records. I have checked the min word lenght which is allowed with: mysql> show variables like '%ft_min_word_len%'; +-----------------+-------+ Variable_name | Value | +-----------------+-------+ ft_min_word_len | 2 | So the word "IT" should be found, because if I search using ... like '% IT %'... there are found some records. Is "IT" a stop word? If yes, how can I make it be a normal word? Thank you. Teddy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]