SELECT
userid,
(
CASE
WHEN `status` = 0 THEN
'未完成'
WHEN `status` = 1 THEN
'已完成'
END
) AS 状态
,`status`
FROM
tradelog
WHERE
userid = 10000001
SELECT
userid,
(
CASE
WHEN `status` = 0 THEN
'未完成'
WHEN `status` = 1 THEN
'已完成'
END
) AS 状态
,`status`
FROM
tradelog
WHERE
userid = 10000001