> From: pgsql-general-ow...@postgresql.org > [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of John R Pierce > Sent: 12 April 2013 08:41 AM > To: pgsql-general@postgresql.org > 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 <iba...@fnb.co.za>: > > 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 (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
