mysql - 多个查询需要合并结果 phpMyAdmin

Question

在 phpMyAdmin 的 SQL 窗口中显示分隔符 ;查询之间。它运行我在其中的所有查询，仅显示最后一个查询的结果。我如何才能将结果合并为一个？

SELECT  field1, field2, field3, field4, field5, field6 
FROM table WHERE field2 = "AA" AND field3 LIKE '%BBB%';
SELECT  field1, field2, field3, field4, field5, field6 
FROM table WHERE field2 = "AA" AND field3 LIKE '%CCC%';

Answer 1

UNION怎么样？

SELECT  field1, field2, field3, field4, field5, field6 
FROM table WHERE field2 = "AA" AND field3 LIKE '%BBB%'
UNION
SELECT  field1, field2, field3, field4, field5, field6 
FROM table WHERE field2 = "AA" AND field3 LIKE '%CCC%';

更新

简化您的查询:

SELECT  field1, field2, field3, field4, field5, field6 
FROM table WHERE field2 = "AA" AND (field3 LIKE '%BBB%' OR field3 LIKE '%CCC%')