title: Convert boolean column to integer
body: <p>In mysql I have a CHAR(1) column containing 'T' and 'F' for true and false. I want to convert this in a single SQL statement to a TINYINT(1) column with 1 and 0. How can I do this without creating a new column? If I do </p>
  
  <pre><code>alter table my_table modify my_column tinyint;
  </code></pre>
  
  <p>then I presume automatic conversion will result in all my rows being replaced with 0. How can I specify a conversion table during column type modification?</p>