title: how to use LIKE with column name
body: <p>Normally <code>LIKE</code> statement is used to check the pattern like data.</p>
  
  <p>example: </p>
  
  <pre><code>select * from table1 where name like 'ar%'
  </code></pre>
  
  <p>My problem is to use one column of table with <code>LIKE</code> statement. </p>
  
  <p>example:</p>
  
  <pre><code>select * from table1, table2 where table1.x is like table2.y%
  </code></pre>
  
  <p>Query above results error . how to use one column data in <code>like</code> query?</p>