title: How to search for rows that are a substring of a value in MySQL?
body: <p>I have a full length item code that I am looking for, <code>'34FDE353UE2'</code> and a table full of a shortened version of said item codes, like this</p>
  
  <pre><code>itemCode
  ============
  34FDE
  35DCF
  34FPE
  ....
  </code></pre>
  
  <p>How can I look through my rows to see if any of them match the <code>'34FDE353UE2'</code>?  In my example, I would hope to get back the first row since <code>34FDE</code> is a substring of <code>'34FDE353UE2'</code>.  How can I write a query to do this?</p>
  
  <p>Using MySQL 5.6.</p>