list order by country

i set the user list order by country (ASC): in this way the users who havent set the country are on the top, there is a way to have this order (by country ASC) but those users at the end?
in other words: first of all the users who set the country

The best approach is to probably filter out users that have no set a country so users with no country aren't displayed at all. I don't think you can double sort like the way you're wanting.

krileon wrote: The best approach is to probably filter out users that have no set a country so users with no country aren't displayed at all. I don't think you can double sort like the way you're wanting.

i don't want a double sort, i just want the users with no country at the bottom of the list instead of top

You'll have to order as DESC instead of ASC so the blank values are placed last instead of first. That's just how SQL orders it.

krileon wrote: You'll have to order as DESC instead of ASC so the blank values are placed last instead of first. That's just how SQL orders it.

in this way i have Z-A order, i guess there is no easy way to do what i want..

in this way i have Z-A order,

Correct, making the blank values last as SQL sees them before A or any other character.

i guess there is no easy way to do what i want..

Only way with Userlists is to filter out the empty values. Normally you'd just do a IF conditioned ORDER BY to have a custom order, but that'd be really slow as it can't be indexed.