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 |
mm******@unl.edu.ar
Programador, Administrador, DBA | Centro de Telemática
Universidad Nacional
del Litoral
-----------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match