来啦,已经跑了好几圈啦....
Canvas is not supported in your browser.

对mysql数据库字符串类型的数字排序

select * from user where  1=1 order by  salary*1 desc limit 0,5  

or

select * from user where  1=1 order by  salary+0  desc limit 0,5

posted @ 2018-10-30 11:22  fangpengcheng_方鹏程  阅读(605)  评论(0编辑  收藏  举报