"Ian Meyer" <[EMAIL PROTECTED]> writes: > 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?
Hmm, none of the responses so far look right to me. How about
WHERE NOT (col ~ '^[A-Za-z0-9]*$')
regards, tom lane
--
Sent via pgsql-general mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
