例如有这样一条语句
select uid from user where uid = 70 or uid =68 or uid = 69;
mysql返回的是
686970
如何让mysql返回
70
68
69
这样的结果,就是按照where的条件先后来返回.
回复内容：
例如有这样一条语句
select uid from user where uid = 70 or uid =68 or uid = 69;
mysql返回的是
金典兑换游戏支付平台程序
下载
本软件完全免费，无任何bug。用户可放心使用，网关需单独注册，请联系软件作者。1、关于接口设置：721K 卡易智能点卡接口，易宝支付网银接口。2、关于账户功能：商户信息管理、玩家留言信箱、网关下载、资金管理。3、关于游戏管理：分区管理、添加分区、分组管理、比例模板、补发管理、获取代码。4、关于订单管理：订单查询、渠道管理、结算统计。5、关于数据统计：玩家排名、分区排名、渠道统计。6、程序是 .NE
686970
如何让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;
