b1nary0mega
4/18/2014 - 7:03 PM

select specified column as alpha-numeric (no special characters) using regex

select specified column as alpha-numeric (no special characters) using regex

alpha-numeric_selection.sql
content_copyfile_download
SELECT regexp_replace(column_name,'[^a-zA-Z0-9]') 
FROM table_name;