Re: Is it possible to search for sub-strings... - Mailing list pgsql-general

From Steve Heaven
Subject Re: Is it possible to search for sub-strings...
Date
Msg-id 3.0.1.32.20000919114426.0072246c@mail.thornet.co.uk
Whole thread Raw
In response to Is it possible to search for sub-strings...  (John Draper <crunch@webcrunchers.com>)
List pgsql-general
At 05:27 19/09/00 -0500, John McKown wrote:
>Assuming that the name of the table is "test1" and the variable containing
>the values of interest is name "values", then:
>
>SELECT * FROM test1 WHERE values LIKE 'JYR%';

or
select * from test1 where values ~ '^JYR';

or for case insensitive:
select * from test1 where values ~* '^JYR';

Steve


--
thorNET  - Internet Consultancy, Services & Training
Phone: 01454 854413
Fax:   01454 854412
http://www.thornet.co.uk

pgsql-general by date:

Previous
From: Andrew.Mason@spektra.co.uk
Date:
Subject: Re: Is it possible to search for sub-strings...
Next
From: Martijn van Oosterhout
Date:
Subject: Controlling the generated plan better