title: trim value in sql where condition
body: <p>I have a row of records in my db <code>abc</code> table, col1 has value '00012345'.</p>
  
  <p>requirement: '00012345' is equal to '12345', trim all the '0' in front.</p>
  
  <p>Here is my sql query:</p>
  
  <pre><code>SELECT * FROM abc WHERE col1 = '12345';
  </code></pre>
  
  <p>This query will not return me any result, unless I change it to </p>
  
  <pre><code>SELECT * FROM abc WHERE col1 LIKE '%12345';
  </code></pre>
  
  <p>But this will break the rules, for example if my value in db is '00912345',
  then '00912345' is not equal to '12345' after trim all the '0' in front.</p>
  
  <p>Kindly advise on how to trim the value in db as well when doing comparison.</p>