Re: Method to detect certain characters in column?

From: Steve Atkins <steve(at)blighty(dot)com>
To: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Method to detect certain characters in column?
Date: 2008-06-23 23:28:12
Message-ID: BC32043C-538D-4A4D-92C0-2996F94DE5D7@blighty.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2008-06-23 23:35:47 Re: Update Join Query
Previous Message Tom Lane 2008-06-23 23:18:05 Re: Method to detect certain characters in column?