pokud to delas v MySQL - musis to napsat treba takhle

Kód:
select 
(case when logname = "kucera"  then 0 else 1 end) as "x",
logname 
from user
order by x, logname;