Mysql使用另一个表来转换值

Question

表用户

+-----+-------+----------+------------+
| id  |  name |  gender  |   computer |
+-----+-------+----------+------------+
| 1   |  ben  |     1    |       3    |
+-----+-------+----------+------------+

表格翻译

+-----+--------+
| id  |  trans |
+-----+--------+
| 1   |   boy  |
| 2   |   girl |
| 3   |   pc   |
| 4   |   mac  |
+-----+--------+

最终结果

+-----+-------+----------+----------+
| id  |  name |  gender  | computer |
+-----+-------+----------+----------+
|  1  |  ben  |  boy     | pc       |
+-----+-------+----------+----------+

我有 2 个表，一个是用户数据，另一个是翻译。

我想使用翻译表来翻译用户的性别和计算机的值有人知道如何实现这一目标吗？

Answer 1

使用加入。

查询

 select 
   t1.`id`,
   t1.`name`,
   t2.`trans` as `gender`,
   t3.`trans` as `computer`
from `user` t1
join `translate` t2
on t1.`gender` = t2.`id`
join `translate` t3
on t1.`computer` = t3.`id`;