Re: Is it possible to search for sub-strings...

I find this useful where you have mixed case:

SELECT * FROM test1 WHERE values ~* 'JYR';


Andrew
----- Forwarded by Andrew Mason/Spektra on 19/09/00 11:38 -----


John McKown <joarmc@swbell.net>
Sent by: pgsql-general-owner@hub.org
19/09/00 11:27


        To:     John Draper <crunch@webcrunchers.com>
        cc:     pgsql-general@postgresql.org
        Subject:        Re: [GENERAL] Is it possible to search for sub-strings...

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%';


On Tue, 19 Sep 2000, John Draper wrote:

> Ok,   I have a question...   lets say I have a key fields like this...
>
> JYR-34a
> JYR-34b
> JYR-34c
> JJG-67
> jUY-89
>
> I want to do a query on a substring,   such that I can get all three
> of the JYR's to come up,   regardless if it has an "a",  "b",   or "c"
> after it.    Is that possible in SQL?    If so,   what would the query
> look like?
>
> John
>
>