title: how to select a query with % in below condition
body: <p>I am not able to return values for below query. The aim of this is I need to return the values depending on id.
  oid are in form <code>123, 123.456, 123.456.789 </code>. So if the result of <code>SELECT id FROM table1 where name = 'Test999'</code>is <code>456</code>. it should return 2 columns i.e., <code>123.456, 123.456.789</code> . I am trying to give a <code>%</code> symbol before the query seems like some syntax error. Tried giving double quotes still no progress.</p>
  <pre><code>SELECT * from table1 where oid like 
  %(SELECT id FROM table1 where name = 'Test999')
  </code></pre>