mysql - 编写具有多个搜索功能的查询？

Question

我正在尝试创建一个查询，其中第一个查询将根据第一个查询的结果返回 COLUMN 第二个查询将执行:

SELECT OBJECT_ID from test.CORRELATION_SET
WHERE (NAME='STATUS' AND VALUE ='SUCCESS')

|OBJECT_ID|
|---------|
|A        |
|B        |
|C        |
|---------|

SELECT * FROM test.CORRELATION_SET
WHERE OBJECT_ID = ('A'|'B'|'C');

Answer 1

查询如下

SELECT * FROM CORRELATION_SET
WHERE OBJECT_ID in (
  SELECT OBJECT_ID from CORRELATION_SET
  WHERE (NAME='STATUS' AND VALUE ='SUCCESS')
)