MySQL Forums
Forum List  »  Full-Text Search

Fulltext search with prefix %like%
Posted by: Ray
Date: September 24, 2005 03:59PM

I do boolean searches using the following format "SELECT field FROM table WHERE MATCH (columnName) AGAINST ('+search* +phrases*' IN BOOLEAN MODE)"

I want to be able to find results where the phrases "search" and "phrases" are in the end of the words as well. Currently, the results only return records where "search" and "phrases" are at the beginning of the words.

It will return a record with a value of

"searching for phrases"

but not for

"anothersearch for morephrases"

I want something similar to the "%search%" and "%phrases%" results when using a LIKE statement.

With thanks
Ray

Options: ReplyQuote


Subject
Views
Written By
Posted
Fulltext search with prefix %like%
6141
Ray
September 24, 2005 03:59PM
2848
October 01, 2005 12:06AM
3237
Ray
October 01, 2005 01:11AM
2501
October 10, 2005 01:06AM


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.