Concat IDs into a single field in SQL
Here is how to merge multiple SQL rows into one, values separated by a comma.
Do it like this:
SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1
Here is how to merge multiple SQL rows into one, values separated by a comma.
Do it like this:
SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1