MySQL column: Change existing phone numbers into specific format?
<p>I have a MySQL column that contains phone numbers, the problem is that they're in different formats, such as:</p>

<ul>
<li>2125551212</li>
<li>212-555-1212</li>
<li>(212)5551212</li>
</ul>

<p>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: <strong>(212) 555-1212</strong></p>

<p>Not a duplicate, as I'm looking to update several thousand entries instead of masking new entries.</p>