如何在drupal中编写sql LIKE查询,
SELECT title FROM { node } WHERE type='%s'
我想在这里添加喜欢的条件
SELECT title FROM { node } WHERE type='%s' AND LIKE '%S%'
我认为我写错了像查询formnat,可以重写并告诉我,
解决方法
只需使用％即可逃脱.
$result = db_query('SELECT title FROM {node} WHERE type = "%s" AND title LIKE "%%%s%%"','type','title');
while ($row = db_fetch_object($result)) {
// do stuff with the data
}
节点类型不需要转义.
