> From: [email protected] > [mailto:[email protected]] On Behalf Of John R Pierce > Sent: 12 April 2013 08:41 AM > To: [email protected] > Subject: Re: [GENERAL] list non alphanumeric > > > > On 4/11/2013 11:23 PM, Baboo, Isa wrote: > > Firstly let me mention I am a noob to postgres,DB and sql anyway, I have a > column with First names and need to list names that have non-alphanumeric > characters in them like + or * and the list goes on. I did google a bit and > tried: > > select * from TABLE where first_name not like '%[a-z0-9]%'; > > > you'll probably have to use a regex for that. > > something like... (my regex is really rusty) > > ... WHERE first_name !~ '^[a-z0-9]*$';
2013/4/12 Baboo, Isa <[email protected]>: > > Hi > > Thanks for the response but I tried that and it does not work here is an > example of names which still display. > > test > sadadds > Hillary > BEN NAME > ALAN MCGARVEY + Something like: ... WHERE first_name ~ '[^\w]' might do the trick. Regards Ian Barwick -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
