title: how to use like query in drupal
body: <p>How to write  SQL LIKE Query in drupal ,</p>
  
  <pre><code>SELECT title FROM { node } WHERE type='%s'
  </code></pre>
  
  <p>i want to add the LIKE CONDITION IN THAT</p>
  
  <pre><code>SELECT title FROM { node } WHERE type='%s' AND LIKE '%S%'
  </code></pre>
  
  <p>i think i writtern wrong like query formnat, can rewrite and tell me, </p>