How to make a Count in Mysql using case or if?

Question

How to make a Count in Mysql using case or if?

Asked 8 years, 3 months ago

Viewed 455 times

1

I need to know how I can do a search in mysql to know how many documents I have to analyze with a condition that if the previous process is not released it cannot count.

SELECT COUNT(`num`),
        CASE  WHEN (`pl_de_manutencao` = 'Liberado' || `pl_de_manutencao` = 'N/A'
            AND `ra_padrao` != 'Liberado' || `ra_padrao` != 'N/A') 
        THEN COUNT(`num`) END AS `Count` 
FROM `ind_master_view`

something like this code.

Try edit and add expected results and their table structure, something like this question.

– Marconi

2016/08/17 at 18:47
already placed to group and it measures the values, however I need the total value

– Gisele

2016/08/17 at 18:50

1 answer

Browser other questions tagged mysql

You are not signed in. Login or sign up in order to post.

by Marco Souza • **12,304** points · Answer 1 · 2016-08-17T19:03:21+00:00

If that’s what I mean, you have to use COUNT() before the 1 increment case if the condition is true .

SELECT COUNT(CASE  WHEN (pl_de_manutencao = 'Liberado' || pl_de_manutencao = 'N/A' 
                        AND ra_padrao != 'Liberado' || ra_padrao != 'N/A') 
                    THEN 1  -- caso a condição seja verdadeira .
            END) AS Total
FROM ind_master_view