Hi It still displaying everything, maybe it is the spaces?
test sadadds Hillary BEN NAME BOB /+ ...skipping ALAN MCGARVEY + -----Original Message----- From: Ian Lawrence Barwick [mailto:[email protected]] Sent: 12 April 2013 09:08 AM To: Baboo, Isa Cc: John R Pierce; [email protected] Subject: Re: [GENERAL] list non alphanumeric > 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 To read FirstRand Bank's Disclaimer for this email click on the following address or copy into your Internet browser: https://www.fnb.co.za/disclaimer.html If you are unable to access the Disclaimer, send a blank e-mail to [email protected] and we will send you a copy of the Disclaimer. -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
