title: mysql: contain in mysql query
body: <p>I am facing issue with database query. 
  Here is the query which i have at the moment.</p>
  
  <pre><code>SELECT tn_id,title,content,type,post_as,city, state,country,pincode,datetime FROM user_posts 
      where deleted = 0 and state like "%delhi ncr%" order by datetime DESC  limit 15
  </code></pre>
  
  <p>Now you can see i am using like in query for state name. In database value is written 'Delhi'. When i run the query it is returning 0 records.
  Seems like <strong>like</strong> is not going to use in this situation.</p>
  
  <p>I am not sure how can i fix this issue. </p>
  
  <p>I also tried <strong>INSTR(name, 'foo')</strong></p>