title: Storing UUID in MySQL considering query performance
body: <p>We are working on designing a table's column in MySQL which is intended to store a binary(16) data generated using <code>newid()</code> function in SQL Server (e.g. <code>0xA6D42A825114472FAF402180E20B3751</code>). </p>
  
  <p>This data is present in our application as a java String like <code>A6D42A825114472FAF402180E20B3751</code> .</p>
  
  <p>Our main use case is to query the table in MySQL on this column based on the String value in our app. What would be the most efficient way to store it in MySQL if we consider query performance ? (We figured out that space wise using binary(16) should be the most efficient way)</p>