|
Hi 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]%';
However the above shows all the entries in that column and if I change it to Like, which should show all the entries it shows nothing. e.g of my goal: Column Bob Jane+ Harry* John Mike Larry My query should output Jane+ Harry* To read FirstRand
Bank's Disclaimer for this email click on the following address or copy into
your Internet browser: If you are unable to
access the Disclaimer, send a blank e-mail to firstrandbankdisclaimer@xxxxxxxxx
and we will send you a copy of the Disclaimer. |
