摘要:
select (SELECT GROUP_CONCAT(NAME) FROM hsb_user_type WHERE FIND_IN_SET (id,a.user_type_id)) AS typeName, a.* , e.job_id as jobId,e.province_id as prov 阅读全文
摘要:
-- 1:case when --SELECT CASE WHEN (admin_id IS NULL) THEN '无创建人' WHEN (admin_id = 0) THEN '管理员' ELSE admin_id END AS admin_idFROM hsb_investor-- 2:if 阅读全文