multiple counts in single mysql query

Question

How can I do multiple counts for the same field in mysql? The code below for a single count works fine

SELECT fruit, COUNT(DISTINCT site) AS `apple` FROM grocery where fruit like '%06201%'

However, when I have tried this but I get syntax error

SELECT
    SUM(fruit like '%06201%') AS `apple`,
    SUM(fruit like '%02206%') AS `pears`,
FROM grocery

tobspr · Accepted Answer · 2013-08-23 11:35:03Z

3

SELECT
    SUM(fruit like '%06201%') AS `apple`,
    SUM(fruit like '%02206%') AS `pears`,
                                        ^
                                        here
FROM grocery

You have two commata, but you only need one.

answered Aug 23, 2013 at 11:35

tobspr

8,4265 gold badges36 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Santosh Pillai Over a year ago

Ah that work, thanks. I was sure I was doing something silly :)

Vahid Hallaji · Accepted Answer · 2013-08-23 11:37:39Z

1

Remove extra comma before FROM

SELECT
    SUM(fruit like '%06201%') AS `apple`,
    SUM(fruit like '%02206%') AS `pears`
FROM grocery

answered Aug 23, 2013 at 11:37

Vahid Hallaji

7,5576 gold badges46 silver badges52 bronze badges

Collectives™ on Stack Overflow

multiple counts in single mysql query

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related