Обсуждение: Search

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

On Mon, 5 Feb 2001, Sebastian --[ www.flashhilfe.de ]-- wrote:

> 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.

LIKE is case-sensitive.  You should convert your column to uppercase:

WHERE UPPER(field) LIKE ...

or use case-insensitive regular expression:

WHERE field ~* '<regexp>'

-- Brett                                    http://www.chapelperilous.net/~bmccoy/
---------------------------------------------------------------------------
The Angels want to wear my red shoes.    -- E. Costello

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
>
>

Thank you!!!

It works perfect !!

Regards, Sebastian


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

Hi,

You seem want to match string insensitively, I guess.
Try:
~* 'test'  -- match Test|tEst|tESt ...
~* '.*test.*'  -- match whateverTesTwhatever

Jie LIANG

Internet Products Inc.

10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873

jliang@ipinc.com
www.ipinc.com

On Mon, 5 Feb 2001, Sebastian --[ www.flashhilfe.de ]-- wrote:

> 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
> 
>