title: how to change (strip) multiple column names using MySQL
body: <p>I have a table with column names like so:
      BLAH_Q1_NAME, BLAH_BLAH_Q2_AGE, BLAH_UGLY_BLAH_Q3_DATE_OF_BIRTH, etc.</p>
  
  <p>I want to be able to change the column names to strip away all of the name before the "Q#" portion, such that I end up with column names that look like so:
      Q1_NAME, Q2_AGE, Q3_DATE_OF_BIRTH, etc.</p>
  
  <p>There are 40+ variables in this table, which prohibits me simply doing this manually.  (I hope!!)  Is there any way to do this in MySQL?  Thanks!</p>