sql - Count number of times value appears in column in MySQL

Question

Tried looking everywhere for this but my searching hasn't given me any answers. Looking to count how many times the word 'Sydney' comes up in the column 'Suburb'

CustomerId  FirstName   LastName    StreetAddress   Suburb  PostCode
C001    James           Smith       400 Kent St     Sydney      2000
C002    Maria           Carpenter   333 Smith St    Westmead    2145
C003    Dennis          Miller      214 Uni Rd      Sydney      2000

I want it to provide an outcome like:

numCustomersFromSydney
                    2

Answer 1

Use this simple query:

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