Search Postgresql Archives

Re: Select Command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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)

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
       message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux