mysql - 从两个 id 中查找具有相同值的行

Question

我正在寻找一个查询来从我的函数的两个participant_id参数中获取对话id:

获取conversation_id的Php函数

public function findByUsers($user1,$user2)

Mysql表participant_conversation

+--------------+-------------------------+
|participant_id| participant_conversation|
+--------------+-------------------------+
|42360         |1                        |
+--------------+-------------------------+
|42362         |5                        |
+--------------+-------------------------+
|42363         |1                        |
+--------------+-------------------------+

感谢帮助

编辑:我找到了解决方案

SELECT DISTINCT ( participant_conversation ) 
FROM users_conversations_participants 
WHERE participant_id IN ( 42360, 42361 ) 
GROUP BY participant_id 
LIMIT 0 , 30

Answer 1

这是问题所在:

$sql = "SELECT participant_id, participant_conversation FROM participant_conversation WHERE participant_id IN ($user1, $user2)";

然后可以简单地使用 while 循环来获取各自的participant_conversion。