title: Convert hex string to number in mySQL
body: <p>I have a column that has the value '11B3' in it.  I want to write a SQL statement (in mySQL) that ands (&amp;) that value with 0x1880 and returns the result.  I have been unable to treat the string column as a hex number.  I would be grateful for any assistance.</p>
  
  <p>This does NOT work:</p>
  
  <pre><code>select szVersion,  hex(szVersion), concat("0x",szVersion)
  </code></pre>
  
  <p>This functions as desired (but doesn't pull from database:</p>
  
  <pre><code>select 0x11bx &amp; 0x1880
  </code></pre>