title: Replace Spaces in Column Name with Underscore MySQL
body: <p>I have inherited a MySQL database that contains many columns in many tables that have spaces in their names.  I have been asked to change all spaces in column names to underscores.  Is there a way to do this with a script?</p>
  
  <p>I thought that I can get them all listed with a SELECT from information_schema.... but I am not sure how to I can do the replacement.</p>
  
  <p>My logic would be that if the column name contains a space, replace it with an underscore.  But I am not sure how to do that.</p>