mysql计数出现一个字符串

I need to count how many times a couple categories appear in a column. They're storred as strings like Sports, Medicine, the column name is ct.category_name. I need to count how many times a couple categor