mysql - 在 "case"的语句中使用 "where in"-

Question

我想在我的网站上应用多语言支持。我创建了一个这样的表:

id | textID | langID |   text   | status
1  | 1453   | 36     | sign up  |  1
2  | 1453   | 147    | kayıt ol |  1
3  | 1454   | 36     | login    |  1

我创建了一个这样的sql:

SQL;

SELECT `textID`
     , `text` 
  FROM `text` 
 WHERE `langID` = ( CASE WHEN `langID` = '147' and `status` THEN '147' ELSE '36' END ) 
   and `textID` in ('1453','1454')

结果；

textID  | text
1453    | sign up
1453    | kayıt ol
1454    | login

1453,1454 位于“where in”内，但我的代码显示 1453 的两种语言，我应该如何执行一种语言或默认语言的 sql？

Answer 1

SELECT `textID`, `text` 
FROM `text` 
WHERE `textID` IN (1453, 1454) AND `langID` = 147

UNION

SELECT `textID`, `text`
FROM `text` 
WHERE `textID` NOT IN (
    SELECT `textID` 
    FROM `text` 
    WHERE `textID` IN (1453, 1454) AND `langID` = 147
) AND `langID` = 36