title: mysql join if string contains similar values
body: <p>Assuming I have a table that has column Description with below values:
  <br><code>His name was Jacob King</code>
  <br><code>One of the guy was Jacob. He was taller than them</code></p>
  <p>How do I join these two rows (in MySql) since they both contain the word Jacob? There will be more rows with other words too so Jacob is not the only word than can appear in more than one row. What I want is a way of joining rows with similar words appearing in them.
  I tried using left join with LIKE keyword as shown below but it didn't work since i am just looking for similar word in sentences <br>
  <code>select * from (SELECT id,description FROM `statement`) f1 </code><br>
  <code>left JOIN (SELECT id,description FROM `statement`) f2 </code><br>
  <code>on f1.description like concat('%' ,f2.description,'%')</code></p>
  <p>The above doesn't work, I think because I am looking for a word as opposed to the entire sentence</p>