SELECT * FROM 用户表 ORDER BY IFNULL(nickname, realname);

SELECT IFNULL(NULL,10); -- > 10