有问题MySQL查询如何通过多个ID的

Question

全部代码，我用它来筛选：

$query18 = 'SELECT group_concat(id) as qc10 FROM tblorders WHERE date LIKE \'' . date ('Y-m-') . '%\''; 
    $result18 = mysql_query($query18); 
    $data18 = mysql_fetch_array($result18); 
    $qc10 = $data18['qc10']; 
    $query19 = "SELECT count(id) as qc11 FROM bl_orderitems WHERE orderid=$qc10"; 
    $result19 = mysql_query($query19); 
    $data19 = mysql_fetch_array($result19); 

$ query19看起来是这样的：

'SELECT count(id) FROM bl_orderitems WHERE orderid=7,6,8,9,10,11,12,13,14'; 

但它不工作。我如何列出这些ID以便实际工作？

谢谢！

Answer 1

使用WHERE orderid IN(7,6,8,9,10,11,12,13,14)

所以查询将是：

'SELECT count(id) FROM bl_orderitems WHERE orderid IN(7,6,8,9,10,11,12,13,14)'; 

Answer 2

如果你正在寻找匹配的OrderID是的，你列出的选项之一的值，这应该工作：

SELECT count(orderid) FROM bl_orderitems WHERE orderid IN (7,6,8,9,10,11,12,13,14); 

Answer 3

尝试使用IN

SELECT count（id）FROM bl_orderitems在哪里（7,6,8,9,10,11,12,13,14）