php - 如何在mysql查询的if条件语句中调用子查询

Question

我有两个表 table1 和 table2。当 status=1 时我需要 table1 的值

    SELECT type, no, 
        CASE WHEN status = '0' THEN 'Vacant'
             WHEN status = '2' THEN 'Repair'
             ELSE (SELECT `field1` FROM `table1` WHERE `field2`=10) AS test END AS addr 
FROM table2

此查询输出错误 #1064

如何在单个 MYSQL 查询中获取值？

Answer 1

SELECT type, no, 
    CASE WHEN status = '0' THEN 'Vacant'
         WHEN status = '2' THEN 'Repair'
         WHEN status = '1' (SELECT `field1` FROM `table1` WHERE `field2`=10) END AS addr FROM table2

如果你尝试这段代码那么你不会得到错误