SELECT `row`, COUNT(`row`) AS cnt FROM `table` GROUP BY `row`