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