title: SQL LIKE from multiple table
body: <p>I want to create a search bar that could list the product name and product owner.</p>
  
  <blockquote>
    <p>Table ITEM consist of pID (FK from PROFILE), itemName, and itemDate</p>
    
    <p>Table PROFILE consist of pID, firstName, and lastName</p>
  </blockquote>
  
  <p>Initially, the <code>'%$Keurig%'</code> supposed to be <code>'%$searchtag%'</code> (the value passed from search bar).</p>
  
  <p>However since it didn't show anything, I decided to use <code>'%$Keurig%'</code> to find out what happened. </p>
  
  <p>Turns out, it didn't show anything as well.</p>
  
  <p>Here's what I wrote:</p>
  
  <pre><code>SELECT I.itemName,P.firstName,P.lastName
        FROM `ITEM` I, `PROFILE` P
        WHERE I.pID=P.pID AND I.itemName LIKE '%$Keurig%'
  </code></pre>
  
  <p>It supposed to print a user name John because he is the only one that owns Keurig.</p>
  
  <p>Anybody knows what I did wrong? Thank you.</p>