Full text search does not find some specific words, which not included in stop words Full text search does not find some specific words, which not included in stop words
I am implementing the full text search on table called programming_language. It contains multiple rows with 'name' column such as java, javascript, etc.
Initially I didn't full text index so I did the following:
ALTER TABLE `Example`.`programming_language`
ADD FULLTEXT INDEX `fi_name` (`name`) WITH PARSER ngram VISIBLE;
-- This returns nothing
After this, full text search seems to work for most of the rows. However, some words such as 'java' aren't found by query. My sql look like following
select * from programming_language
where match(name)
against("java" IN NATURAL LANGUAGE MODE);
-- This returns nothing
or
select * from programming_language
where match(name)
against("java" IN BOOLEAN MODE);
-- This returns nothing
(also tried java* but didn't work as well)
I am expecting to get back java and javascript, but none of them get returned. Is there anything wrong with my sql?
I am fairly new to this topic and would appreciate for any helps.
from Stackoverflow
Comments
Post a Comment