MYSQL之GROUP_CONCAT函数忽略空字符串列和内部排序

1、忽略空字符串列：GROUP_CONCAT(IF(column1 = "", NULL, column1) SEPARATOR ";")

2、 支持 ORDER BY 内部排序：GROUP_CONCAT(column1 ORDER BY column1 DESC)

3、原始数据：
 

SELECT 
  question_no AS 题号,
  GROUP_CONCAT(answer 
    ORDER BY answer ASC) AS 答案,
  GROUP_CONCAT(
    IF(
      other_content = '',
      NULL,
      other_content
    )
  ) AS 其他内容,
  uid AS 用户ID 
FROM
  `jm_answer` 
GROUP BY question_no,
  uid 
ORDER BY uid ASC,
  question_no ASC;

SELECT 
  question_no AS 题号,
  GROUP_CONCAT(answer 
    ORDER BY answer ASC) AS 答案,
  GROUP_CONCAT(
    IF(
      other_content = "",
      NULL,
      other_content
    ) SEPARATOR ";"
  ) AS 其他内容,
  uid AS 用户ID 
FROM
  `jm_answer` 
GROUP BY question_no,
  uid 
ORDER BY uid ASC,
  question_no ASC;