title: Get the first character of the field in MySQL
body: <p>I have a table </p>
  
  <p>table_1</p>
  
  <pre><code>col_1
  ----------
  1.where
  2.how
  20.there
  </code></pre>
  
  <p>How can I get the number from the table when I select col_1 from the table</p>
  
  <p>output </p>
  
  <pre><code>1
  2
  20
  </code></pre>
  
  <p>Use trim?</p>