I've set 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.
My table:
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)
);
My query:
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.