title: How to use LIKE clause to compare two columns in the same table?
body: <p>I need to verify if the value of Column_1 is contained in the values of Column_2. The type of data in the 2 columns are:</p>
  
  <pre><code>ID   |   column1    |  column2           |
  ----------------------------
  1   |   apple       |  pear,grape, apple |
  2   |   pear        |  apple,grape       |
  3   |   apple       |  apple             |
  </code></pre>
  
  <p>The query should return to me the lines 1 and 3.</p>
  
  <p>I've tried something like this, but doesn't work:</p>
  
  <pre><code>SELECT * FROM `table` as C WHERE column_1 LIKE "%C.column_2%"
  </code></pre>