1SELECT
2 GROUP_CONCAT(DISTINCT id SEPARATOR ', ') AS 'ids'
3FROM
4 table_name
5WHERE
6 column_name = 'value'
1mysql count multiple columns in one query:
2 SELECT
3 count(*) as count_rows,
4 count(col1) as count_1,
5 count(col2) as count_2,
6 count(distinct col1) as count_distinct_1,
7 count(distinct col2) as count_distinct_2,
8 count(distinct col1, col2) as count_distinct_1_2
9 FROM `table` ;