Re: Search - Mailing list pgsql-sql

From PM
Subject Re: Search
Date
Msg-id 95otrr$hjg$1@news.tht.net
Whole thread Raw
In response to Search  ("Sebastian --[ www.flashhilfe.de ]--" <hallogammler@aol.com>)
List pgsql-sql
force lower case or use the non case-senstitive search e.g.

lower(column) LIKE lower('%$suchbegriffe[$i]%')

or

column ~* '$suchbegriffe[$i]'
(no need for wildcards when using ~* it assumes %value%)



"Sebastian --[ www.flashhilfe.de ]--" <hallogammler@aol.com> wrote in
message news:95n58g$5fa$1@news.tht.net...
> Hi
>
> I hope someone can help me....
>
> My problem:
>
> I have make a search machine whit:
>
> LIKE '%$suchbegriffe[$i]%'
>
> but when I search Test - the search machine shows only entries
> whit Test. But not test or tESt.
>
> (sorry for my bad english)
>
> Regards, Sebastian
>
>




pgsql-sql by date:

Previous
From: "Alain Lavigne"
Date:
Subject: SQL question
Next
From: "Sebastian"
Date:
Subject: Re: Search