MySQL 查询数据并修改符合条件的字段的显示内容

笔记：MySQL 查询数据并修改符合条件的字段的显示内容

SELECT     A.*,

(CASE A.Status WHEN 2 THEN '***' ELSE   B.Name END) AS Name ,
(CASE A.Status WHEN 2 THEN '***' ELSE   B.Address END) AS Address ,
(CASE A.Status WHEN 2 THEN '***' ELSE   B.PhoneNum END) AS PhoneNum ,

B.Sex,  B.Race, B.Birth_Date, B.ID_Card, B.Age
FROM  student_socre AS A INNER JOIN student_info AS B ON A.Student_Id=B.Student_Id WHERE CAST(A.Subject AS CHAR) LIKE '%物' OR  B.Name  LIKE '%李'

ORDER BY A.Student_Id DESC