title: MySQL join query using like?
body: <p>I have been trying to get this working for quite a while now but it just doesn't seem to work, maybe it is is not even possible, what i am wanting to do is to perform a MySQL join query using like, such as this example i found...</p>
  
  <pre><code>SELECT *
  FROM Table1
  INNER JOIN Table2 ON Table1.col LIKE '%' + Table2.col + '%'
  </code></pre>
  
  <p>but it just doesn't seem to work at all, any help that can be given would be brilliant, thanks !</p>