Re: Method to detect certain characters in column?

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