yzc261亚洲城官网备用地址Mysql查询数据返回排序

( yzc261亚洲城官网备用地址 )

例如有这样一条语句

select uid from user where uid = 70 or uid =68 or uid = 69;

mysql返回的是

68
69
70

如何让mysql返回

70
68
69

这样的结果,就是按照where的条件先后来返回.

SELECT id, name
FROM mytable
WHERE name IN B, A, D, E, C
ORDER BY FIELDname, B, A, D, E, C

网上随便找下就有了

select uid from user where uid in 70 ,68 , 69 order by fine_in_setuid,70,68,69;

select uid from user where uid = 70 or uid =68 or uid = 69 order by uid desc

select uid from user where uid = 70 or uid =68 or uid = 69 order by uid desc;

(看完/读完)这篇文章有何感想! yzc261亚洲城官网备用地址的分享…

发表评论

电子邮件地址不会被公开。 必填项已用*标注