title: Joining two tables using the LIKE operator
body: <p>I'm trying to join two tables based on two values being alike. I have this so far but I'm getting a SQL error as soon as I use the <code>%</code>.</p>
  
  <pre><code>SELECT downloads.d_key, payer_email
  FROM    paypal_log
  INNER JOIN
          downloads
  ON      downloads.d_key LIKE "%" + paypal_log.custom + "%"
  </code></pre>
  
  <p>The <code>downloads.d_key</code> will be within the <code>paypal_log.custom</code>.</p>
  
  <p>Any help appreciated with this.</p>