MySQL ORDER BY rand（），name ASC [英] MySQL ORDER BY rand(), name ASC

问题描述

我想要一个数据库，说1000个用户，并选择20个随机的（ ORDER BY rand（）， LIMIT 20 ），然后按名称对结果集排序。

I would like to take a database of say, 1000 users and select 20 random ones (ORDER BY rand(),LIMIT 20) then order the resulting set by the names. I came up with the following query which is not working like I hoped.

SELECT * FROM users WHERE 1 ORDER BY rand（），name ASC LIMIT 20

SELECT * FROM users WHERE 1 ORDER BY rand(), name ASC LIMIT 20

推荐答案

使用子查询：

SELECT * FROM 
(
    SELECT * FROM users ORDER BY rand() LIMIT 20
) T1
ORDER BY name 

内部查询随机选择20个用户，外部查询命令选择的用户按名称。

The inner query selects 20 users at random and the outer query orders the selected users by name.

这篇关于MySQL ORDER BY rand（），name ASC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！