instr()查询不工作

Question

$condition = '200,310'; //these are numbers of pages for news to be driven out of

while (list($key,$nesto) = each($pluginid))
{
 $getnm = $DB->query("SELECT articleid, categoryid FROM " . TABLE_PREFIX . "p".$nesto."_newy
                    WHERE lang = '$userlang'
                    AND settings > 0
                    **AND instr(categoryid, $condition)**
                    ORDER BY settings ASC, datecreated DESC");
$rows = $DB->get_num_rows($getnm);
}

此instr不工作。你知道怎么做吗？categoryid只包含一个数字。

Answer 1

如果你想检查categoryid是否是$condition中提供的任何一个，你必须改变参数的位置：

AND instr('$condition', categoryid) > 0

Answer 2

尝试使用IN而不是INSTR。IN可以使用索引，并且可能比INSTR更快。

$DB->query("SELECT articleid, categoryid FROM " . TABLE_PREFIX . "p".$nesto."_newy
  WHERE lang = '$userlang'
  AND settings > 0
  AND categoryid IN ($condition)
  ORDER BY settings ASC, datecreated DESC");