mysql order by 字段为空的时候,如果想为空的数据排在后面,加上is null SELECT * FROM `school_spot` order by vote_num is null; 按照参赛的编号来显示