Regarding FTS and Like queries

[Devrishi Shandilya]

Hi,

I new with full text search, I have an issue that i have a table catalog_product_entity_varchar that has billions of records (44500000+) and it has a field named value and most of query written in as to search

where `value` like '%Hitachi Brush Cutter%'

I want to use FTS on field value and get benefit of FTS, How can I do this as results are different of both queries, seems something wrong.

select * from catalog_product_entity_varchar where `value` like '%Hitachi Brush Cutter%'
select * from catalog_product_entity_varchar where match(`value`) against ('Hitachi Brush Cutter')

I have user search in natural and bolean mode, but result are not same.

Pl suggest, i am using mysql 5.6.value field is varchar(255) with charset utf8 and table is innodb.