Re: Search

From: "Sebastian" <pchous45(at)saxnet(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: Search
Date: 2001-02-06 13:47:48
Message-ID: 95ov9k$huk$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Thank you!!!

It works perfect !!

Regards, Sebastian

PM <pmeloy(at)home(dot)negate(dot)spam(dot)com> schrieb in im Newsbeitrag:
95otrr$hjg$1(at)news(dot)tht(dot)net(dot)(dot)(dot)
> 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%)

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brett W. McCoy 2001-02-06 14:09:55 Re: Search
Previous Message Alain Lavigne 2001-02-06 13:37:41 SQL question