Re: Search - Mailing list pgsql-sql

From Jie Liang
Subject Re: Search
Date
Msg-id Pine.BSF.4.10.10102061014510.45535-100000@tidal.ipinc.com
Whole thread Raw
In response to Search  ("Sebastian --[ www.flashhilfe.de ]--" <hallogammler@aol.com>)
List pgsql-sql
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
> 
> 



pgsql-sql by date:

Previous
From: Jie Liang
Date:
Subject: Re: CREATE TABLE AS and ORDER BY
Next
From: "J.Fernando Moyano"
Date:
Subject: type casting: varchar to date