use this
regular expression
~
regular expression - case insensitive
~*
example
SELECT name FROM table1 where name
~* '*Ã*'
check here
http://www.postgresql.org/docs/current/static/functions-matching.html
--- El lun 23-jun-08, Ian Meyer <[EMAIL PROTECTED]> escribió:
De: Ian Meyer <[EMAIL PROTECTED]>
Asunto: [GENERAL] Method to detect certain characters in column?
A: pgsql-general@postgresql.org
Fecha: lunes, 23 junio, 2008, 5:58 pm
So I have a column that contains usernames that have characters such
as Ã(c)(R), for example: fuchÃ(c)r.. is there any way to find names
with non A-Za-z0-9?
Thanks in advance!
- Ian
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
