Re: Method to detect certain characters in column?

Ah, so I forgot to mention the one caveat to this (sorry!) was there
was a ton of punctuation/spaces and other ilk.. so this is what I came
up with:

bco=# select name from member where not (name ~ '^[A-Za-z0-9[:punct:] ]*$');
name
----------------------
Señorita Lolita
Long Pig
täkäurgh
blåbärsöl
fuchér MkII
fuchér ver2.0
Gûm-ishi Ashi Gurum
kängnäve
Fuchér-version 2.1
fuchÃ(c)r

Thank you everyone for your help.. that looks to be the correct amount
I was looking for.

Ian
On Mon, Jun 23, 2008 at 7:28 PM, Steve Atkins <steve(at)blighty(dot)com> wrote:
>
> 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
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>