MYSQL MATCH...AGAINST returning no results -

i baffled one.

i working on ecommerce website, , have table full of test products. in table field called 'name' of type text , has fulltext index.

i inserted few hundred rows of dummy data, every single row inserted "test product" (without quotes) it's value in 'name' field.

however, running following command returns 0 results, though word 'product' in name field every row.

select name products match (name) against ('product')

i have checked server variables, set default values. min characters 4, stopwords default etc. far can tell, product not stopword.

if there further information can provide might find resolution problem let me know.

many in advance.

from mysql documentation on fulltext searches, search query considered triggering stop word relevant string present in rows.

the 50% threshold has significant implication when first try full-text searching see how works: if create table , insert 1 or 2 rows of text it, every word in text occurs in @ least 50% of rows. result, no search returns results. sure insert @ least 3 rows, , preferably many more. users need bypass 50% limitation can use boolean search mode

here link refer boolean full-text searches