LIKE can use indexes, ~* can not, that's LIKE's main advantage (at least in
my opinion).
-Mitch
----- Original Message -----
From: "Steve Heaven" <steve@thornet.co.uk>
To: "John Draper" <crunch@webcrunchers.com>
Cc: <pgsql-general@postgresql.org>
Sent: Tuesday, September 19, 2000 3:44 AM
Subject: Re: [GENERAL] Is it possible to search for sub-strings...
> 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
>
