Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
405 views
in Technique[技术] by (71.8m points)

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

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
See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Answer

0 votes
by (71.8m points)

Use this simple query:

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

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome to OStack Knowledge Sharing Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...