title: Use '%' with column names in MYSQL select statement?
body: <p>I have a query that looks at partial matches within two mysql tables to make a join:</p>
  
  <pre><code>SELECT table1.column, table2.column FROM table1, table2 WHERE table1.val LIKE table2.val
  </code></pre>
  
  <p>This works fine as a join, but... some of the values in table2 are actually substrings of the values in table one—specifically they're urls. So, table1.val might equal <a href="http://google.com" rel="nofollow">http://google.com</a> while table2.val = google.com. </p>
  
  <p>How do I use the '%' operator around the table2 val to make this comparison.</p>
  
  <p>Thanks in advance!</p>