mysql：包含在mysql查询中

I am facing issue with database query. Here is the query which i have at the moment.

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

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 like is not going to use in this situation.

I am not sure how can i fix this issue.

I also tried INSTR(name, 'foo')

Finally it fixed by using locate keyword.

SELECT tn_id,title,content,type,post_as,city, state,country,pincode,longitude,latitude,datetime,full_location FROM user_posts 
    where deleted = 0 and locate(state, '%Delhi ncr%') order by datetime DESC  limit 15

Hope it helps someone.