title: MySQL column: Change existing phone numbers into specific format?
body: <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>