I have created full text search in my database
its showing wrong result for in Boolean mode search
SELECT * FROM catalgo_auto_productdetails WHERE product_name like '%htc%'
showing correct result
SELECT * FROM catalgo_auto_productdetails WHERE MATCH (`product_name`)
AGAINST ('htc' IN BOOLEAN MODE)
showing empty result