MySQL Forums
Forum List  »  MyISAM

FullText problem 'start with' or 'end with'
Posted by: giulio fitini
Date: September 08, 2014 09:35AM

Hi to everyone!!
I'm tryng to do some 'fullText' queries.
I've to do some kinds of queries, to find words, that 'starts with' or 'end with'.

For example, i've an example text : "Everyday is a good day to workout".

I want to find, with 'fullText' query, each row who 'start with' : "work*", or 'end with' : "*out".

So, for the first kind of query :

SELECT ID_DETAIL,TEXT_DATA FROM log_detail where match (TEXT_DATA) against ('work*' IN BOOLEAN MODE)

and it works fine...

while, when i try to find something that 'end with'...

SELECT ID_DETAIL,TEXT_DATA FROM log_detail where match (TEXT_DATA) against ('*out' IN BOOLEAN MODE)

this, don't find anything...while i thinked that found each row who contains strings like ('workout',etc..)

...so... what's the problem??

i'm using MySql 5.5

thanks in advance

Options: ReplyQuote


Subject
Views
Written By
Posted
FullText problem 'start with' or 'end with'
2801
September 08, 2014 09:35AM


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.