Re: Method to detect certain characters in column?

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(at)gmail(dot)com> escribió:
De: Ian Meyer <ianmmeyer(at)gmail(dot)com>
Asunto: [GENERAL] Method to detect certain characters in column?
A: pgsql-general(at)postgresql(dot)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