Do not select records that have the status='Off' field

Question

$query = "SELECT uf , count(*) as number FROM tab_clientes GROUP BY uf ";

It is working perfectly but I have in the bank a status field that classifies the person as Off (need to continue registered for other reports).

I would like the records not to enter the above query when the field status='Desligado'.

Answer 1

Just use a where

$query = "SELECT uf , count(*) as number " .
         "FROM tab_clientes " .
         "WHERE status <> 'Desligado'" .
         "GROUP BY uf ";