title: Rename Multiple MySQL Columns With Regex Possible?
body: <p>I have a mysql database with multiple tables that have column names like somename_fr for storing translations in different languages.</p>
  
  <p>I need to rename them to somename_fr_CA, so just tack on the _CA part. </p>
  
  <p>Is this possible to do with a query that will update them all at once?</p>