Advanced Search

Return to Snippet

Revision: 61729
at January 10, 2013 13:50 by tucq88
Initial Code 
SELECT 
  id,
  user_id,
  defeated_login_boss_id,
  number_of_times,
  SUM(number_of_times) AS total 
FROM
  tb_user_login_boss_collections 
WHERE defeated_login_boss_id = 2
GROUP BY user_id 
HAVING total > 9
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
By using HAVING 'virtual_field' CONDITION we can add conditions to virtual fields that created at SELECT

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
[MySQL] Add condition to Virutal Fields

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
mysql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
MySQL