Like and Where in the same MySQL query

I would like to use something like 开发者_JAVA百科the following:

SELECT city FROM cities WHERE city LIKE %D% AND country_id = '12'

---

You need to quote the string

SELECT city FROM cities WHERE city LIKE '%D%' AND country_id = '12'

But remember that using a LIKE with a pattern starting with a "%" means the server will NOT use an index on 'city' column - it may not matter in your specific case but something to be aware of. Here's the reference since your comment indicates you're not familiar with indexes.

---

Bit late to the show... But I had the same problem when using it as a "search" feature. Remember in PHP, you need to concatenate it or it might break... Like this

$query="SELECT city FROM cities WHERE city LIKE '%".$searchterm."%' AND country_id = '12'"

Maybe not relevant to you but if like me you looked around for ages to find out why the "search term" was not being put in in a recognisable format, this might help.