mysql - Select * from table where id=(很多不同的值)...如何编写可以执行此功能的查询？

Question

我有两个表 register 和 bar，它们与字段 id_register 链接。我有以下查询

$query="select * from register where register.id_register=(select bar.id_register from bar where bar.confirm='1' AND bar.confirm2='0') ";<br><br>

$run=mysql_query($query);<br>
while ($row=mysql_fetch_array($run))<br>
{ 
    echo " $row[id_register]." ; <br>
    echo " $row[another-field]." ;  
}

我需要帮助来解决这个问题:
这个查询释放了一个错误，因为当搜索register.id_register (where register.id_register=(select bar.id_register from bar where bar.confirm='1 ' AND bar.confirm2='0') 在数据库上发现了很多 id 值。
我该如何解决这个问题？是否有另一个 mysql 函数可以用来以正确的方式选择数据？ ？

Answer 1

您可以在此处使用IN子句。

The IN operator allows you to determine if a specified value matches any one of a list or a subquery. The following illustrates the syntax of the IN operator.

引用: http://www.mysqltutorial.org/sql-in.aspx

语法:

SELECT 
  column1,column2,...
FROM
  table_name
WHERE 
  (expr|column_1) IN ('value1','value2',...);

试试这个:

$query = "SELECT * FROM register WHERE register.id_register IN (SELECT bar.id_register FROM bar WHERE bar.confirm='1' AND bar.confirm2='0') ";