> From: pgsql-general-owner@xxxxxxxxxxxxxx > [mailto:pgsql-general-owner@xxxxxxxxxxxxxx] On Behalf Of John R Pierce > Sent: 12 April 2013 08:41 AM > To: pgsql-general@xxxxxxxxxxxxxx > Subject: Re: 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 <IBaboo@xxxxxxxxx>: > > 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
