Re: Fast LIKE search
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.
Subject
Views
Written By
Posted
15335
May 23, 2009 10:09AM
6906
May 24, 2009 12:41PM
5496
May 25, 2009 10:27AM
Re: Fast LIKE search
4348
May 25, 2009 12:58PM
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.