MySQL Forums
Forum List  »  Optimizer & Parser

Advanced Search
New Topic

Re: Fast LIKE search
Posted by: andrew browne
Date: May 25, 2009 12:58PM

Hmmm, using "match(field) against ('input*' IN BOOLEAN MODE)"

gives me words beginning with 'input', but not containing 'input'.

However pondering it further, I'm thinking people won't type the middle

part of a word into a search box. So this works, and better than LIKE

it searches all the words separately. (the field in question contains

between one and three words). So I guess this is a sort of compromise solution.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Fast LIKE search
15263
andrew browne
May 23, 2009 10:09AM
Re: Fast LIKE search
6866
Rick James
May 24, 2009 12:41PM
Re: Fast LIKE search
5450
andrew browne
May 25, 2009 10:27AM
Re: Fast LIKE search
4303
andrew browne
May 25, 2009 12:58PM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

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.