@yahoogroups.com
Assunto: [firebird-support] Case insensitive search on a memo field
Hi,
I'm using Firebird 2.5.3, and I am looking for text in a emo field, eg.
Select * from mytable t where t.mymemo like '%find me%'
The will only find
find me
and not
FIND ME or
Find me
Select * from mytable t where t.mymemo like '%find me%'
You can create a computed index for this:
CREATE INDEX idxname ON mytable COMPUTED BY (lowercase(mymemo))
Such an index does not help for LIKE '%...', it can only be used if the first
character is a real character (i.e. not % or _).
I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
I’m tempted to do something like
Select * from mytable t where lowercase(t.mymemo) like ‘%find me%’
but since this memo field could be enormous, I’m guessing that wold be
horribly inefficient.
I use upper() for that
On Fri, Sep 5, 2014 at 8:43 AM, Stefan Heymann li...@stefanheymann.de
[firebird-support] firebird-support@yahoogroups.com wrote:
I’m using Firebird 2.5.3, and I am looking for text in a emo field, eg.
I’m tempted to do something like
Select * from mytable t where lowercase(t.mymemo) like
On 05/09/2014 17:18, Ann Harrison aharri...@ibphoenix.com
[firebird-support] wrote:
What's needed is a full-text index, which Firebird doesn't offer. Lucene
and others produce full-text indexes that can be used with Firebird (I
think, haven't tried it).
Apparently the Sphinx full-text