MySQL column: Change existing phone numbers into specific format?

I have a MySQL column that contains phone numbers, the problem is that they're in different formats, such as: 2125551212 212-555-1212 (212)5551212 I'd like to know if it's possible to take the existing 10 digits, remove the formatting, and change them all to this format: (212) 555-1212 Not a duplicate, as I'm looking to update several thousand entries instead of masking new entries. Solution: Sample data create table nums ( num text ); insert into nums values      ('2125551212'),     ('212-555-1212'),  ...