title: compatibility Query for to_number()
body: <p>In this query using <code>to_number()</code> in oracle. How to write compatibility query for oracle and mysql databases.</p>
  
  <pre><code>SELECT col1 FROM table WHERE condition ORDER BY TO_NUMBER(col2);
  </code></pre>
  
  <p>Here <code>col2</code> is <code>varchar2</code> datatype. Suppose i was used <code>ORDER BY</code> command in this query must use converting function i.e <code>to_number(col2)</code>,this function not available in mysql.so please give correct solution for above problem</p>