Can I concatenate multiple MySQL rows into one field?

Question

Aryan Kumar · Answer

Yes, you can concatenate multiple MySQL rows into one field using the GROUP_CONCAT() function. The syntax is as follows:

SQL

SELECT GROUP_CONCAT(column_name, SEPARATOR) AS column_name
FROM table_name
GROUP BY column_name;

For example, if you have a table called products with the columns name and price, you could use the following query to concatenate all product names into a single field:

SQL

SELECT GROUP_CONCAT(name, ',') AS names
FROM products
GROUP BY name;

This would return a single field with a comma-separated list of all product names.

Here is an example of how to use the GROUP_CONCAT() function in MySQL:

SQL

CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);

INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300);

SELECT GROUP_CONCAT(name, ',') AS names
FROM products
GROUP BY name;

This will return the following result:

names
Product 1,Product 2,Product 3

As you can see, the GROUP_CONCAT() function has concatenated all product names into a single field, separated by commas.

Here are some additional things to keep in mind when using the GROUP_CONCAT() function:

The GROUP_CONCAT() function only works with string columns.
You can use the SEPARATOR keyword to specify a different separator character than a comma.
You can use the DISTINCT keyword to remove duplicate values from the results.

forum

Can I concatenate multiple MySQL rows into one field?

Can you answer this question?

1 Answers