mysql find_in_set函数以及group_concat

找到子部门(Mysql)

BEGINDECLARE sTemp VARCHAR(500);DECLARE sTempChd VARCHAR(500);SET sTemp = '';SET sTempChd =parId;WHILE sTempChd is not null DOSET sTemp = concat(sTemp,',',sTempChd);SELECT group_concat(department_code) INTO sTempChd FROM department where <strong>FIND_IN_SET(upper_department_code ,sTempChd)</strong>>0;END WHILE;RETURN sTemp;END

另外今天才知道MYSQL GROUP_CONCAT支持内部排序，涨知识了...

SELECTGROUP_CONCAT(CASEWHEN leave_type IS NULL THENNULLELSECONCAT(RIGHT (date_id, 4),':请',(SELECTvalue_chinese_nameFROMcommon_parameterWHEREcollection_code = 'QJLX'AND value_code = a.leave_type))ENDORDER BYdate_id) commentsFROMattendance a;