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 -

php - Bypass Geo Redirect for specific directories -

php - .htaccess mod_rewrite for dynamic url which has domain names -