MySQL Forums
Forum List  »  Full-Text Search

Re: Truncate operator in quoted expression?
Posted by: Jay Pipes
Date: June 27, 2005 02:43PM

I guess, the short answer to your last question:

"Basically, I guess I'm asking if there's any way to get the truncation
operator to actually function inside a quoted expression?"

is: no.

FULLTEXT indexes are built on complete words (minus the stopwords), not parts of words. The syntax which behaves the way you are expecting is the LIKE and REGEXP expressions, not MATCH/AGAINST.

The only way I can think of to help you out would be to standardize the data before putting into this column. You can run it through an expression to clean up the street address and standardize it, optionally breaking the single field into three or four fields, like StreetNo, StreetName, etc. This will get the address data into the most efficient format for indexing by non-FULLTEXT indexes. FULLTEXT indexes really weren't meant for this type of scenario...

Jay Pipes
Community Relations Manager, North America, MySQL Inc.

Got Cluster? http://www.mysql.com/cluster
Personal: http://jpipes.com

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Truncate operator in quoted expression?
2702
June 27, 2005 02:43PM


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.