natasha_sharma Posted January 29, 2016 Share Posted January 29, 2016 Friends, I am using MySQL Full Text Search to categorise the strings based on keywords found. If i make a condition like: 1) 'Institutional' then will it find a hit on string "Analyst/Institutional Presentation" 2) '+"Credit Rating" then will it find a hit on string "Credit Rating." (Observe a Period at the End) I mean there are loads of examples. My question is, I want to ignore these leading/ trailing special characters and match only the Word. Any Help on how to do this please? Thanks Natasha S. Quote Link to comment https://forums.phpfreaks.com/topic/300694-mysql-full-text-search/ Share on other sites More sharing options...
QuickOldCar Posted January 29, 2016 Share Posted January 29, 2016 Wrapping with double quotes in the query is exact matches. +(\"Credit Rating\") https://dev.mysql.com/doc/refman/5.5/en/fulltext-boolean.html Quote Link to comment https://forums.phpfreaks.com/topic/300694-mysql-full-text-search/#findComment-1530578 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.