I ran into this problem a few months ago and the only workaround I could
think of was to escape the quotes in the table with """. Then your query
should be something like this
select * from feeds where MATCH(feed_title, feed_content) AGAINST('"Sean
"P. Diddy" +Combs"' IN BOOLEAN MODE) order by
I'm using a boolean query to perform an exact match on musicians within a text
field. However, if the musician's name contains a quote, I get inaccurate
results. For example, this query works fine:
select * from feeds where MATCH(feed_title, feed_content) AGAINST('"Tom Petty"'
IN BOOLEAN MODE)