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 quot;. Then your query
should be something like this
select * from feeds where MATCH(feed_title, feed_content) AGAINST('Sean
quot;P. Diddyquot; +Combs' IN BOOLEAN MODE)
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)