mysql - 如何让mysql为where子句中提供的每个键输出行，即使它是重复的

Question

我想在 where 子句中获得重复键的重复输出。是否可以这样做。

我看过

例如当我查询时

SELECT name FROM table WHERE id IN (3,3,4) 

我想要输出:

+----+-------+
| id | name  |
+----+-------+
| 3  | tiger |
| 3  | tiger |
| 4  | lion  |
+----+-------+

Answer 1

根据MYSQL文档

UNION followed with ALL keyword is used to combine the result from multiple SELECT statements including duplicate rows into a single result set.

根据上述描述作为问题的解决方案，请尝试执行以下 SQL 选择查询。

select name from table A where id in (3,3)
UNION ALL
select name from table A where id in (3,3)