Re: Select Non Alpha Contents of a Column - Mailing list pgsql-general

From Martin Marques
Subject Re: Select Non Alpha Contents of a Column
Date
Msg-id 200312292035.30451.martin@bugs.unl.edu.ar
Whole thread Raw
In response to Select Non Alpha Contents of a Column  (Hunter Hillegas <lists@lastonepicked.com>)
List pgsql-general
El Lun 29 Dic 2003 20:11, Hunter Hillegas escribió:
> Is there a way to select all rows where a certain column starts with
> non-alpha characters?
>
> I would like to select all the rows that don't start with letters.
>
> Possible?

SELECT * FROM table_name WHERE col !~* '^a-z'

--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-----------------------------------------------------------------
Martín Marqués                  |        mmarques@unl.edu.ar
Programador, Administrador, DBA |       Centro de Telemática
                       Universidad Nacional
                            del Litoral
-----------------------------------------------------------------


pgsql-general by date:

Previous
From: Tony
Date:
Subject: Re: Is my MySQL Gaining ?
Next
From: Martin Marques
Date:
Subject: Re: [pgsql-advocacy] Is my MySQL Gaining ?