<bdo id='ibAJ0'></bdo><ul id='ibAJ0'></ul>
<legend id='ibAJ0'><style id='ibAJ0'><dir id='ibAJ0'><q id='ibAJ0'></q></dir></style></legend>
      1. <tfoot id='ibAJ0'></tfoot>

        <i id='ibAJ0'><tr id='ibAJ0'><dt id='ibAJ0'><q id='ibAJ0'><span id='ibAJ0'><b id='ibAJ0'><form id='ibAJ0'><ins id='ibAJ0'></ins><ul id='ibAJ0'></ul><sub id='ibAJ0'></sub></form><legend id='ibAJ0'></legend><bdo id='ibAJ0'><pre id='ibAJ0'><center id='ibAJ0'></center></pre></bdo></b><th id='ibAJ0'></th></span></q></dt></tr></i><div id='ibAJ0'><tfoot id='ibAJ0'></tfoot><dl id='ibAJ0'><fieldset id='ibAJ0'></fieldset></dl></div>

      2. <small id='ibAJ0'></small><noframes id='ibAJ0'>

        按预定义顺序返回查询结果

        时间:2023-06-01
        • <small id='u37PD'></small><noframes id='u37PD'>

            <tbody id='u37PD'></tbody>
          <legend id='u37PD'><style id='u37PD'><dir id='u37PD'><q id='u37PD'></q></dir></style></legend>

            <i id='u37PD'><tr id='u37PD'><dt id='u37PD'><q id='u37PD'><span id='u37PD'><b id='u37PD'><form id='u37PD'><ins id='u37PD'></ins><ul id='u37PD'></ul><sub id='u37PD'></sub></form><legend id='u37PD'></legend><bdo id='u37PD'><pre id='u37PD'><center id='u37PD'></center></pre></bdo></b><th id='u37PD'></th></span></q></dt></tr></i><div id='u37PD'><tfoot id='u37PD'></tfoot><dl id='u37PD'><fieldset id='u37PD'></fieldset></dl></div>

              <tfoot id='u37PD'></tfoot>
              • <bdo id='u37PD'></bdo><ul id='u37PD'></ul>

                • 本文介绍了按预定义顺序返回查询结果的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着跟版网的小编来一起学习吧!

                  问题描述

                  是否可以按预定顺序执行 SELECT 语句,即.选择 ID 7、2、5、9 和 8 并按该顺序返回,仅基于 ID 字段?

                  Is it possible to do a SELECT statement with a predetermined order, ie. selecting IDs 7,2,5,9 and 8 and returning them in that order, based on nothing more than the ID field?

                  这两个语句都以相同的顺序返回它们:

                  Both these statements return them in the same order:

                  SELECT id FROM table WHERE id in (7,2,5,9,8) 
                  

                  SELECT id FROM table WHERE id in (8,2,5,9,7)
                  

                  推荐答案

                  我不认为这是可能的,但找到了一个 此处的博客条目 似乎是您所追求的类型:

                  I didn't think this was possible, but found a blog entry here that seems to do the type of thing you're after:

                  SELECT id FROM table WHERE id in (7,2,5,9,8) 
                  ORDER BY FIND_IN_SET(id,"7,2,5,9,8");
                  

                  会给不同的结果

                  SELECT id FROM table WHERE id in (7,2,5,9,8) 
                  ORDER BY FIND_IN_SET(id,"8,2,5,9,7");
                  

                  FIND_IN_SET 返回给它的第二个参数中 id 的位置,因此对于上面的第一种情况,7 的 id 在集合中的位置 1, 2 at 2 等等 - mysql 内部计算出类似

                  FIND_IN_SET returns the position of id in the second argument given to it, so for the first case above, id of 7 is at position 1 in the set, 2 at 2 and so on - mysql internally works out something like

                  id | FIND_IN_SET
                  ---|-----------
                  7  | 1
                  2  | 2
                  5  | 3
                  

                  然后根据FIND_IN_SET的结果进行排序.

                  then orders by the results of FIND_IN_SET.

                  这篇关于按预定义顺序返回查询结果的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持跟版网!

                  上一篇:将数据从javascript发送到mysql数据库 下一篇:“193:%1 不是有效的 Win32 应用程序"新 Rails 应用程序的错误

                  相关文章

                    <small id='5JG96'></small><noframes id='5JG96'>

                      <tfoot id='5JG96'></tfoot>
                      <i id='5JG96'><tr id='5JG96'><dt id='5JG96'><q id='5JG96'><span id='5JG96'><b id='5JG96'><form id='5JG96'><ins id='5JG96'></ins><ul id='5JG96'></ul><sub id='5JG96'></sub></form><legend id='5JG96'></legend><bdo id='5JG96'><pre id='5JG96'><center id='5JG96'></center></pre></bdo></b><th id='5JG96'></th></span></q></dt></tr></i><div id='5JG96'><tfoot id='5JG96'></tfoot><dl id='5JG96'><fieldset id='5JG96'></fieldset></dl></div>

                        <bdo id='5JG96'></bdo><ul id='5JG96'></ul>

                    1. <legend id='5JG96'><style id='5JG96'><dir id='5JG96'><q id='5JG96'></q></dir></style></legend>