GROUP_CONCAT() function is used to concatenate column values into a single string. Note that this function will not count null values. This is very useful if you need records from database with multiple rows in single string with specified seperator(e.g. Comma seperated). This situation will come in one to may relation of tables. You may get this error while retriving records using joins. “Operand should contain 1 column(s)”.