Re: Method to detect certain characters in column?

From: Tommy Gildseth <tommy(dot)gildseth(at)usit(dot)uio(dot)no>
To: ianmmeyer(at)mac(dot)com
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Method to detect certain characters in column?
Date: 2008-06-23 21:13:04
Message-ID: 486011E0.1090108@usit.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ian Meyer wrote:
> 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?

...WHERE col ~ '[^a-zA-Z0-9]';

Someone with a bit more regex fu can probably condense down the regex.

--
Tommy Gildseth

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Antonio Perez 2008-06-23 21:22:46 Re: Method to detect certain characters in column?
Previous Message Ian Meyer 2008-06-23 20:58:15 Method to detect certain characters in column?