Mysql full text seach not working for 2 or 3 characters -


i created fulltext seach index , set ft_max_word_len=1.

when do:

select * tablename  match (title,description,content) against ('ニ')  order tablename.start_time limit 50 

or when do:

select * tablename match (title,description,content)  against ('ニュース') order tablename.start_time limit 50 

it show 50 record.

but when do:

 select * tablename match (title,description,content)   against ('ニュ') order tablename.start_time limit 50 

or when do:

select * tablename match (title,description,content)  against ('ニュー') order tablename.start_time limit 50 

it shows empty result.

can explain why?


Comments

Popular posts from this blog

Magento/PHP - Get phones on all members in a customer group -

spring cloud - How to configure SpringCloud Eureka instance to point to https on non standard port -

javascript - Bootstrap Popover: iOS Safari strange behaviour -