文章介绍了如何通过ORDER BY语句和FUNCTION字段来控制MySQL查询返回的结果顺序，使其按照WHERE子句中条件的先后顺序排列。示例包括使用FIELD()函数和FIND_IN_SET()函数，确保uid值按照68, 69, 70的顺序返回。
例如有这样一条语句
select uid from user where uid = 70 or uid =68 or uid = 69;
mysql返回的是
68
69
70
如何让mysql返回
70
68
69
这样的结果,就是按照where的条件先后来返回.
回复内容：
例如有这样一条语句
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 FIELD(name, 'B', 'A', 'D', 'E', 'C')
网上随便找下就有了
select uid from user where uid in( 70 ,68 , 69) order by fine_in_set('uid','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;
本文原创发布php中文网，转载请注明出处，感谢您的尊重！
298
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
