Mysql查询数据返回排序

WBOY
WBOYオリジナル
2016-06-06 20:10:031051ブラウズ

例如有这样一条语句

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的条件先后来返回.

<code>SELECT id, name
FROM mytable
WHERE name IN ('B', 'A', 'D', 'E', 'C')
ORDER BY FIELD(name, 'B', 'A', 'D', 'E', 'C')</code>

网上随便找下就有了

<code class="php">select uid from user where uid in( 70 ,68 , 69) order by fine_in_set('uid','70,68,69');</code>

<code>select uid from user where uid = 70 or uid =68 or uid = 69 order by uid desc</code>

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

声明:
この記事の内容はネチズンが自主的に寄稿したものであり、著作権は原著者に帰属します。このサイトは、それに相当する法的責任を負いません。盗作または侵害の疑いのあるコンテンツを見つけた場合は、admin@php.cn までご連絡ください。