ft_min_word_len = 1 to
my.cnf file, also
SHOW VARIABLES LIKE 'ft_min_word%' displays
ft_min_word_len as 1. Then I've reloaded all database tables and it still doesn't search for one character words.
CREATE TABLE IF NOT EXISTS event ( id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, name VARCHAR(80) NOT NULL, description TEXT, time TIMESTAMP DEFAULT 0, FULLTEXT(name) );
SELECT event.id AS eid, event.name AS ename FROM event WHERE MATCH(event.name) AGAINST('+W*' IN BOOLEAN MODE)
And event name I'm searching for is
W.W.W. + Pavel Fajt + Vladimir 518 @ Sono
What else could cause the problem please?
EDIT: I'm using InnoDB, sorry I haven't mention it before.