title: how to compare two varchar values with leading zeros in mysql
body: <p>I have to compare 2 columns in mysql which has varchar data type. But there are some data which has leading '0'  which is creating problem while comparing.</p>
  
  <p>For ex: <strong>I have to compare between '02653' and '2653' which are actually equal, but here my query fails and gives different result.</strong></p>
  
  <p>Please suggest any idea what should be the right query for this.</p>
  
  <p>I have tried to run like this 
  <strong>SELECT DISTINCT <code>table1</code>.<code>store_id</code> 
  FROM <code>table2</code>
  WHERE 
  CONVERT('first_column' AS INTEGER) = CONVERT('second_column' AS INTEGER)</strong>   </p>
  
  <p>Showing this error<br>
  ** for the right syntax to use near AS INTEGER **</p>