Postgres Pro
Downloads
Home   >   mailing lists

Re: Method to detect certain characters in column? - Mailing list pgsql-general

From Steve Atkins
Subject Re: Method to detect certain characters in column?
Date
Msg-id BC32043C-538D-4A4D-92C0-2996F94DE5D7@blighty.com
Whole thread Raw
In response to Method to detect certain characters in column?  ("Ian Meyer" <ianmmeyer@gmail.com>)
Responses Re: Method to detect certain characters in column?  ("Ian Meyer" <ianmmeyer@gmail.com>)
List pgsql-general
Tree view 
On Jun 23, 2008, at 1:58 PM, 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 column ~* '[^a-z0-9]'

Cheers,
   Steve

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Method to detect certain characters in column?
Next
From: Craig Ringer
Date:
Subject: Re: Update Join Query