Mysql group_concat ignoring empty row column

Question

The MYSQL group_concat () function by default ignores null columns, but does not ignore empty row columns. I have a field of type mediumtext, not null. When I use the group_concat function, the request generates an unwanted ",," this type of value. How can i avoid this? Thank you in advance for your precious time.

Answer 1

Move empty string to null:

NULLIF(column1,'') 

• NULLIF (expr1, expr2) :
  • Returns NULL if expr1 = expr2

Answer 2

Use GROUP_CONCAT with IF(expr1,expr2,expr3) , suppose you want concat column1 :

 GROUP_CONCAT(IF(column1='', null, column1))