Count number of times value appears in particular column in MySQL March 9, 2023 by Tarik select email, count(*) as c FROM orders GROUP BY email