Re: Search

From: "PM" <pmeloy(at)home(dot)negate(dot)spam(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Search
Date: 2001-02-06 13:28:40
Message-ID: 95otrr$hjg$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)aol(dot)com> wrote in
message news:95n58g$5fa$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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
>
>

In response to

  • Search at 2001-02-05 21:21:51 from Sebastian --[ www.flashhilfe.de ]--

Responses

  • Re: Search at 2001-02-06 13:47:48 from Sebastian

Browse pgsql-sql by date

  From Date Subject
Next Message Alain Lavigne 2001-02-06 13:37:41 SQL question
Previous Message Michael Ansley 2001-02-06 13:16:06 RE: PL/PGSQL function with parameters