From: | Martin Marques <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | Hunter Hillegas <lists(at)lastonepicked(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Select Non Alpha Contents of a Column |
Date: | 2003-12-29 23:35:30 |
Message-ID: | 200312292035.30451.martin@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)unl(dot)edu(dot)ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Martin Marques | 2003-12-29 23:40:49 | Re: [pgsql-advocacy] Is my MySQL Gaining ? |
Previous Message | Tony | 2003-12-29 23:29:28 | Re: [GENERAL] Is my MySQL Gaining ? |