Thursday, January 16, 2014

mysql query Sorting certain values to the top

Hay guys you can see the query as same result but execution speed
--------------------------------------------------- 
(
SELECT * FROM cyb_jm_master_countries_m WHERE country_name = "United States"
) UNION (
SELECT * FROM cyb_jm_master_countries_m WHERE country_name != "United States"
)
---------------------------------------------------- 
OR
 
SELECT  * 
FROM cyb_jm_master_countries_m
ORDER  BY  `country_name`  =  'United States' DESC ,  `country_name`  ASC 
LIMIT 0 , 30
 
  


No comments:

Post a Comment