CODE EXAMPLE FOR SQL

postgres regular expression replace

SELECT regexp_replace('jhon@gmail.com','[^w]+','');