Sign In/My Account | View Cart  

advertisement

AddThis Social Bookmark Button

Article:
  Using Regular Expressions in PostgreSQL
Subject:   Selecting non-displayable chars using regex
Date:   2006-06-27 04:11:41
From:   btv-ucs
I would like to know how can I use regex to retrieve data on my system that has characters in that are not normal keyboard chars. is there a simpler way of doing than hardcoding each char like below :
select name from user wher name !~* '[a-z0-9.!@] ;


I want to find all the data on my database that has got chars like '^c' ect.


Thanks