clear markdown compare help best fiddles feedback dbanow.uk a leap of faith?
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 1130665 fiddles created (16591 in the last week).

WITH yourTable AS ( SELECT '+1-123-456-7890' AS phone UNION ALL SELECT '+1 1234567890' UNION ALL SELECT '+6512345678' ) SELECT phone, REPLACE(REPLACE(REPLACE(phone, ' ', ''), '+', ''), '-', '') AS common_phone FROM yourTable WHERE phone REGEXP '\\+[0-9][[:space:]-][0-9]{3}-?[0-9]{3}-?[0-9]{4}';
phone common_phone
+1-123-456-7890 11234567890
+1 1234567890 11234567890
 hidden batch(es)