MySQL Forums
Forum List  »  Full-Text Search

Words with and without single quotes and returning both using Match Against
Posted by: Jason Wilson
Date: November 18, 2009 03:57PM

i am attempting to write a simple query where a search for "men's" and a search for "mens" will both return the same results, but using a full-text search.

select col1 from table1 where MATCH (col1,col2) AGAINST ('men\'s')
or
select col1 from table1 where MATCH (col1,col2) AGAINST ('mens')

either of these queries would ideally return rows with "men's" or "mens" but it does not of course.

trying to figure out a method to accomplish the same thing as:
select col1 from table1 where replace(col1, "'", "") like '%mens%'

thanks...

Options: ReplyQuote


Subject
Views
Written By
Posted
Words with and without single quotes and returning both using Match Against
4939
November 18, 2009 03:57PM


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.