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 <ianmmeyer@xxxxxxxxx> escribió:
De: Ian Meyer <ianmmeyer@xxxxxxxxx>
Asunto: [GENERAL] Method to detect certain characters in column?
A: pgsql-general@xxxxxxxxxxxxxx
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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general |
