SELECT
id,
(
CASE
test_type
WHEN 1
THEN '疾病自查'
WHEN 2
THEN '心理测试'
ELSE '中医体质辨识'
END
) AS testTypeName,
buwei,
test_id AS testId,
create_time AS createTime
FROM
cd_test_record
WHERE mbrID = #{mbrId} ORDER BY create_time desc
mysql sql-case使用
最新推荐文章于 2024-06-23 17:08:46 发布