MYSQL group_concat() function by default ignore null columns but it didn't ignore empty string columns. I have a field which is mediumtext type and not null. When I am using group_concat function on that the query generated unwanted ',,,' this type of value. How can i avoid this? Thanks in advance for your valuable time. MYSQL group_concat() function by default ignore