我有一些表还原用户的文章。表格结构就像..。
id | uid | imgae |
1 | 1 | 1.jpg |
2 | 1 | |
3 | 2 | 2.jpg |
4 | 3 | 3.jpg |
5 | 3 | |
6 | 3 | 4.jpg |
7 | 4 | |
...然后我想得到10个结果,witch image!=''
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)
UNION
(select * from my_table where image!='' order by rand() limit 1)以及如何进行进一步的查询。10个不同uid (a.uid!=b.uid)的结果?代码太长了..。有什么简单的方法吗?谢谢。
发布于 2012-03-04 18:12:07
更改限制并包含一个分组依据:
select * from my_table where image!='' order by rand() group by uid limit 10发布于 2012-03-04 18:16:35
你为什么不这样做:
SELECT * FROM my_table
WHERE image != ''
ORDER BY RAND()
LIMIT 10如果你只是想要DISTINCT uid,你可以这样做:
SELECT DISTINCT uid, id, image FROM my_table
WHERE image != ''
ORDER BY RAND()
LIMIT 10(MySQL人员唤醒了我的记忆--当您选择DISTINCT uid时,MySQL会选择相应的id、图像行,还是更像GROUP BY,您不一定会获得相应的行?)
https://stackoverflow.com/questions/9554025
复制相似问题