1 根据值长度排序
SELECT * FROM user ORDER BY LENGTH(relBigPic) desc
2 mysql Host 'XXX' is not allowed to connect to this MySQL serve
flush privileges;
3 根据日期排序
select DATE_FORMAT(time,'%Y%m%d') days,count(1) count from article group by days order by days desc;