makaroni4/trim_column.sql

Created December 11, 2015 15:57

Star () You must be signed in to star a gist
Fork () You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/makaroni4/991e2ce992cb8ccd08c3.js"></script>
Save makaroni4/991e2ce992cb8ccd08c3 to your computer and use it in GitHub Desktop.

Download ZIP

Remove all non digit symbols from column in PostgreSQL

Raw

trim_column.sql

	update fb_audiences
	set facebook_id = replace(facebook_id, '[^0-9]+$', '');

	SELECT id, facebook_id
	FROM fb_audiences
	WHERE facebook_id ~ '[^0-9]+$'

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment