MySQL Forums
Forum List  »  Full-Text Search

Re: issue in full text search using with replace.
Posted by: Rick James
Date: April 15, 2011 10:03PM

Syntax:
MATCH (col1,col2,...) AGAINST (expr [search_modifier])
That is, MATCH(name) -- name must be a column name, not an expression.

Suggest you add an extra column with the sanitized version of `name`. Then apply the FULLTEXT index to it instead of `name`.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: issue in full text search using with replace.
1743
April 15, 2011 10:03PM


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.