如何合并多个查询为一个查询?

Question

select * from table_a where field_a = 1 LIMIT 0, 3;
select * from table_a where field_a = 2 LIMIT 0, 3;
select * from table_a where field_a = 3 LIMIT 0, 3;

如何合并以上３个SQL查询为１个查询？

Answer 1

sqlselect * from table_a where field_a = 1 LIMIT 0, 3
union
select * from table_a where field_a = 2 LIMIT 0, 3
union
select * from table_a where field_a = 3 LIMIT 0, 3;

Answer 2

SELECT * FROM table_a WHERE field_a IN (1, 2, 3)