用LIKE进行SQL查询

Question

I have a weird problem please take a look at this query:

select * from myfriend where name like "%n%";

when execute this query on phpMyAdmin the query returned correct results, but when execute it using php no result returned.

please note this query executed in drupal 6.

what is the problem with char "n" and PHP?

Answer 1

Percent signs are used as placeholders in Drupal 6 queries, so you need to escape them:

$query = db_query('select * from myfriend where name like "%%n%%"');