title: Casting varchar to int in mysql
body: <p>I have a column airline_id which is varchar in the table route, now I want to copy that value into the column airline_id_int which has the type int. I can't get the syntax right though..</p>
  
  <p>This is what I have:</p>
  
  <pre><code>UPDATE route SET airline_id_int = CAST(airline_id, int);
  </code></pre>