我有一个用变量动态构建的查询。我希望我所有的条件也有一个类似的声明。
我的代码是:
$where .= " AND name=" . "'" . $name . "'";
我想使用:
$where .= " AND name Like "%'.$name.'%";
但我不确定如何构建它。
感谢
看起来你走在了正确的轨道上。像这样。。。
$where .= " AND name LIKE '%" . $name . "%'";
但是,当向字符串中添加字段时,我发现使用php sprintf((函数更容易。例如:
$where = sprintf("SELECT * FROM Users WHERE name LIKE '%s' AND status='%s'",
"%" . mysql_real_escape_string($name) . "%",
"active"
);
您可以简单地执行
$where .= " AND name Like '%".$name."'%";
$where .= " AND name Like '%$name%'";
或
$where .= ' AND name Like "%'.$name.'%"';
像这样:
$where .= " AND name LIKE '%".mysql_real_escape_string($name)."%'";