Looking to Build/Redesign a Website or Blog ?

To speak to Rakshit, call +91 968 704 2303

September 29, 2010

No Comments

GROUP_CONCAT MYSQL group by function

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)”.