MySQL Forums
Forum List  »  Full-Text Search

Using wildcards in fulltext searches
Posted by: Andrew Fielden
Date: October 02, 2008 03:14AM

I'm trying to speed up a query of the form

... WHERE desc like '%MSDN%'

by using a fulltext index on the 'desc' column in my table.
However, the equivalent fulltext search clause

... MATCH desc AGAINST ('MSDN')

returns rows matching

...w/MSDN Prem...

but not

...w/MSDNPrem...

I've tried modifying my fulltext search with wildcards i.e.

... MATCH desc AGAINST ('*MSDN*')

but this didn't work, I still didn't get the complete set of matches I expected. Does anyone know what search pattern would achieve this? I've searched previous similar threads on this subject, but not found any answers.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Using wildcards in fulltext searches
24554
October 02, 2008 03:14AM
9857
December 04, 2008 09:14PM


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.