mysql if else使用 case使用

外卖之星

已于 2024-01-03 17:07:56 修改

阅读量172

点赞数

文章标签： mysql

于 2020-12-29 11:11:42 首次发布

本文链接：https://blog.csdn.net/qq_39139352/article/details/111884740

版权

SELECT
    b.id AS "设备拥有者id",
    b. NAME AS "设备拥有者姓名",
    CONCAT(b.tel, '\t') AS "设备拥有者电话",                -- 导出csv时设置成正常文本身份证、手机号、数字订单号等
    CONCAT(a.cdkey, '\t') AS "设备sn码",
    IF (a.fromId = 0, "公司", c. NAME) AS "调拨人姓名",               --  如果为0显示公司，其他显示查询的名称
    IF (a.fromId = 0,"公司",CONCAT(c.tel, '\t')) AS "调拨人电话",
    ( case when a.type = 1 then "采购 "
when a.type = 2 then "兑换"
when a.type = 3 then "激活"
else "其他"
      end)    AS "操作",                                                                    --多条件判断
    FROM_UNIXTIME(a.created_at, '%Y-%m-%d %H:%i:%s') AS "记录时间"    -- 时间戳转换时间格式
FROM
    db_user_pos_record_detail AS a,
    db_user AS b,
    db_user AS c
WHERE
    cdkey = '123456'
AND b.id = a.toId
AND c.id = b.pid