Advanced Search

Return to Snippet

Revision: 44284
at April 9, 2011 01:30 by dsoms
Updated Code 
SELECT
  id,
  sum(if (`user_type` = 1, 1, 0)) as COUNT_TYPE1,
  sum(if (`user_type` = 2, 1, 0)) as COUNT_TYPE2,
  sum(if (`user_type` = 3, 1, 0)) as COUNT_TYPE3,
  sum(if (`user_type` = 4, 1, 0)) as COUNT_TYPE4
FROM users
GROUP BY id

Revision: 44283
at April 9, 2011 01:29 by dsoms
Initial Code 
SELECT
  id,
  sum(if (type = 1, 1, 0)) as COUNT_TYPE1,
  sum(if (type = 2, 1, 0)) as COUNT_TYPE2,
  sum(if (type = 3, 1, 0)) as COUNT_TYPE3,
  sum(if (type = 4, 1, 0)) as COUNT_TYPE4
FROM users
GROUP BY id
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Countif in MySQL

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL