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

Popular posts from this blog

How can I get every LI element's innerHTML and display as string? How can I get every LI element's innerHTML and display as string?

Selenium: Cannot click element Selenium: Cannot click element