Concat IDs into a single field in SQL

Here is how to merge multiple SQL rows into one, values separated by a comma.

SNP 012 #951 Filed sql

Do it like this:

sql
SELECT GROUP_CONCAT(id SEPARATOR ', ') FROM `table_name` WHERE `is_active`=1