blocks|key|4952559|text|首先选择ID为11的图像，然后使用UNION关键字查询其余图像|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4952560|SELECT+*
FROM+Images
Where+ID+=+11
UNION
SELECT+*
FROM+Images
WHERE+ID+!=+11|code-block|syntax|javascript|4952561|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

First select the image with ID 11 and than query the rest with UNION keyword

<pre><code>SELECT *
FROM Images
Where ID = 11
UNION
SELECT *
FROM Images
WHERE ID != 11
</code></pre>

blocks|key|4952654|text|您可以在将它们检索到php之后对它们进行混洗。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4952655|$photos+=+array();
while+($get_photo+=+mysql_fetch_array($photo))
++++$photos[]+=+$get_photo;

shuffle($photos);|code-block|syntax|javascript|4952656|或者，您可以使用子查询完成此操作：|4952657|SELECT+A.*+FROM+(
++++SELECT+*+FROM+`profile_images`+
++++ORDER+BY+(ID+=+11)+DESC,+RAND()++++++
++++LIMIT+7
)+as+A
ORDER+BY+RAND()|4952658|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

You can shuffle them after they are retrieved to php.

<pre><code>$photos = array();
while ($get_photo = mysql_fetch_array($photo))
 $photos[] = $get_photo;

shuffle($photos);
</code></pre>

Or you can do it with subqueries:

<pre><code>SELECT A.* FROM (
 SELECT * FROM `profile_images` 
 ORDER BY (ID = 11) DESC, RAND() 
 LIMIT 7
) as A
ORDER BY RAND()
</code></pre>

blocks|key|1710129|text|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1710130|首先选择特定的图像，然后合并随机收集的其他6张图像。，|ordered-list-item|1710131|When，rand()，，，，你按顺序排序，所有的行都有唯一的随机值进行排序，所以子组不会排序。因此，如果存在rand()，那么在order+by子句中使用更多列将不起作用。因此，我对结果使用了别名，并对其重新排序。|offset|length|style|BOLD|CODE|1710132|1710133|请参阅查询|1710134|(SELECT+*+
+FROM+++`profile_images`+
+WHERE++id+=+11+
+LIMIT++1)+
UNION+
(SELECT+*+
+FROM+++(SELECT+*+
+++++++++FROM+++`profile_images`+
+++++++++WHERE++id+!=+11+
+++++++++ORDER++BY+Rand()+
+++++++++LIMIT++6)+`t`+
+ORDER++BY+id+DESC)+|code-block|syntax|javascript|1710135|entityMap^0|0|0|0|C|D|1|5|6|1J|6|0|0|0|0^^$0|@$1|2|3|-4|4|5|6|U|7|@]|8|@]|9|$]]|$1|A|3|B|4|C|6|V|7|@]|8|@]|9|$]]|$1|D|3|E|4|C|6|W|7|@$F|X|G|Y|H|I]|$F|Z|G|10|H|I]|$F|11|G|12|H|J]|$F|13|G|14|H|J]]|8|@]|9|$]]|$1|K|3|-4|4|5|6|15|7|@]|8|@]|9|$]]|$1|L|3|M|4|5|6|16|7|@]|8|@]|9|$]]|$1|N|3|O|4|P|6|17|7|@]|8|@]|9|$Q|R]]|$1|S|3|-4|4|5|6|18|7|@]|8|@]|9|$]]]|T|$]]

<ol>
<li>First select the specific image then union other 6 images collected by random. </li>
<li>When you sort something by <code>rand()</code> all the rows get unique random value to sort so the subgroups aren't sorted. So using more columns in order by clause does not work if there is <code>rand()</code> present. Hence I have used alias the result and sort it again.</li>
</ol>

See the query

<pre><code>(SELECT * 
 FROM `profile_images` 
 WHERE id = 11 
 LIMIT 1) 
UNION 
(SELECT * 
 FROM (SELECT * 
 FROM `profile_images` 
 WHERE id != 11 
 ORDER BY Rand() 
 LIMIT 6) `t` 
 ORDER BY id DESC) 
</code></pre>

blocks|key|915451|text|如果你只是举个例子，它不需要那么复杂|type|unstyled|depth|inlineStyleRanges|entityRanges|data|915452|SELECT+*+FROM+tbl_table+ORDER+BY+RAND()|code-block|syntax|javascript|915453|这将使您的数据随机化。如果你想限制你显示的图片数量，那么只需输入：|915454|SELECT+*+FROM+tbl_table+ORDER+BY+RAND()+LIMIT+6|915455|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|N|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|O|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|P|8|@]|9|@]|A|$E|F]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Its doesnt need to be that complicated if you just put for example 

<pre><code>SELECT * FROM tbl_table ORDER BY RAND()
</code></pre>

This will randomise your data. if you want to limit out how many images you show then just put:

<pre><code>SELECT * FROM tbl_table ORDER BY RAND() LIMIT 6
</code></pre>

The following code displays random database images as well as one specific image (which is what I want). How can I shuffle these results after database query as image ID 11 is always displayed first? I want image ID 11 displayed randomly amongst the others. 

Can I use SHUFFLE(). If so where exactly do I put it as at the moment?

Any help would be appreciated as still learning PHP

Thanks.

<pre><code>&lt;?php 

mysql_connect("", "", "") or die(mysql_error()) ; 
mysql_select_db("images") or die(mysql_error()) ;


$photo=mysql_query("SELECT * FROM `profile_images` ORDER BY (ID = 11) DESC, RAND() 
LIMIT 7");


while($get_photo=mysql_fetch_array($photo)){ ?&gt;

&lt;div style="width:300px;"&gt;


&lt;img src="&lt;? echo $get_photo['url']; ?&gt;"&gt;


&lt;/div&gt;

&lt;? } ?&gt;
</code></pre>

shuffle random MYSQL results

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

下面的代码显示随机的数据库图像以及一个特定的图像(这就是我想要的)。我如何在数据库查询后混洗这些结果，因为图像ID 11总是首先显示？我希望图像ID 11在其他图像中随机显示。我可以使用SHUFFLE()吗？如果是这样的话，我现在到底应该把它放在哪里？任何帮助都将被视为仍在学习PHP谢谢。<?php mysql_con...

问随机排列MYSQL结果
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问随机排列MYSQL结果EN