mysql - 同表同列不同条件查询

Question

我有这个表(url_table):

+----+---------------+-------------+
| id | language_code |     url     |
+----+---------------+-------------+
| 60 | de            | german_url  |
| 60 | en            | english_url |
| 60 | fr            | france_url  |
| 60 | es            | spanish_url |
+----+---------------+-------------+

我想将这两个查询合并为一个:

SELECT url FROM url_table WHERE id = 60 AND language_code = 'de';
SELECT url FROM url_table WHERE id = 60 AND language_code = 'en';

结果应该是德语和英语 URL，但重命名为 url_de 和 url_en:

url_de: german_url
url_en: english_url

Answer 1

您可以尝试使用in

SELECT url 
FROM url_table 
WHERE id = 60 AND language_code in ('de','en');

根据您期望的结果，您可以尝试使用 concat 函数。

查询#1

SELECT concat('url_',language_code ,':',url)
FROM url_table
WHERE id = 60 AND language_code in ('de','en');

| concat('url_',language_code ,':',url) |
| ------------------------------------- |
| url_de:german_url                     |
| url_en:english_url                    |

<小时/>

View on DB Fiddle