[Solved] Count number of times value appears in column in MySQL

Use this simple query:

select count(*) as numCustomersFromSydney from table where Suburb = "Sydney";