MySQL Forums
Forum List  »  Full-Text Search

Regarding FTS and Like queries
Posted by: Devrishi Shandilya
Date: January 09, 2016 04:23AM


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.

Options: ReplyQuote

Written By
Regarding FTS and Like queries
January 09, 2016 04:23AM
January 10, 2016 05:36PM
January 22, 2016 06:38PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.