Re: Is it possible to search for sub-strings...
От | Mitch Vincent |
---|---|
Тема | Re: Is it possible to search for sub-strings... |
Дата | |
Msg-id | 007b01c02252$af01fe60$0200000a@doot обсуждение исходный текст |
Ответ на | Is it possible to search for sub-strings... (John Draper <crunch@webcrunchers.com>) |
Ответы |
Re: Is it possible to search for sub-strings...
|
Список | pgsql-general |
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 >
В списке pgsql-general по дате отправления: