MySQL Forums
Forum List  »  InnoDB

Advanced Search
New Topic

Multiple / Single phrase serach using Full Text is not working
Posted by: PIYALI GHOSH DOSTIDAR
Date: January 15, 2015 01:47PM

Hi Team,

I was trying to search using Fulltext by the following query
select * from test where MATCH (TEST_NOTES) Against ('"New York"' in Boolean mode);on MYSQL server 5.7(used InnoDB engine), the problem that I faced is it also returns row where it found "York" instead of whole phrase which is incorrect but the same query I tried in MYSQL Server 5.5(used MyISAM engine) and it searched for the "New York" as whole word i.e phrase not as individual word and its working fine.

Please help me out as I have to use MySQL Server 5.7 and InnoDB engine for the table.

Regards,
Piyali

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Multiple / Single phrase serach using Full Text is not working
1911
PIYALI GHOSH DOSTIDAR
January 15, 2015 01:47PM
Re: Multiple / Single phrase serach using Full Text is not working
893
Rick James
January 16, 2015 12:10PM
Re: Multiple / Single phrase serach using Full Text is not working
925
PIYALI GHOSH DOSTIDAR
January 17, 2015 01:58PM


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.