是否有与mySQL的IN等效的PHP? [英] Is there a php equivalent to mySQL's IN?

问题描述

在用mySQL编写select语句时，如果我要提取列值等于多个值之一的记录，我可以这样说:

In writing select statements in mySQL, if I want to pull records where a column value equals one of a number of values, I can say something like this:

SELECT * FROM myTable WHERE myColumn IN(1,5,7)

是用OR在PHP中完成类似操作的唯一方法吗?

Is the only way to accomplish something similar in PHP with OR?

if($category == 1 || $category == 5 || $category == 7) {
   // do something
}

推荐答案

请参见 in_array() 函数.

See the in_array() function.

例如:

$list = array(1, 5, 7);
if (in_array($category, $list)) {
  // do something
}

或者更紧凑:

if (in_array($category, array(1, 5, 7))) {
  // do something
}

这篇关于是否有与mySQL的IN等效的PHP?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！