title: How to find certain Hex values and Char() Values in a MySQL SELECT
body: <p>Anyone know the syntax to search a MySQL table column by hex value or CHAR() value?  Do I have to use a LIKE or IN()?</p>
  
  <p>Something like:</p>
  
  <pre><code>SELECT * FROM `myWordTable` WHERE `definition` LIKE 0xE28098;
  </code></pre>
  
  <p>OR </p>
  
  <pre><code>SELECT * FROM `myWordTable` WHERE `definition` LIKE CHAR(128);
  </code></pre>
  
  <p>Thanks!</p>