Re: Select Command

Поиск
Список
Период
Сортировка
Искать
От
Alvaro Herrera
Тема
Re: Select Command
Дата
Msg-id
20071021220108.GB12111@alvh.no-ip.org
Ответ на
Select Command (Bob Pawley)
Список
Дерево обсуждения
Select Command Bob Pawley <rjpawley@shaw.ca>
Re: Select Command Adrian Klaver <aklaver@comcast.net>
Re: Select Command Richard Broersma Jr <rabroersma@yahoo.com>
Re: Select Command Alvaro Herrera <alvherre@commandprompt.com>
Bob Pawley wrote:
> I have a column with data structured as follows.
> 
> 32TT - 0002
> 32LT- 0004
> 32PT-0005
> 
> Is there a way of selecting all of the rows containing LT in that column??
> 
> 
> I have attempted variations of ' *LT* ' with out success.

LIKE '%LT%' perhaps?

Or ~ 'LT' (unanchored regex)

-- 
Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"El número de instalaciones de UNIX se ha elevado a 10,
y se espera que este número aumente" (UPM, 1972)
В списке pgsql-general по дате отправления
От: Bob Pawley
Дата:
Сообщение: Select Command
От: andy
Дата:
FAQ