ORDER BY FIELD()

最新推荐文章于 2023-05-17 15:37:55 发布
最新推荐文章于 2023-05-17 15:37:55 发布
阅读量1.3k 收藏
点赞数
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_37699037/article/details/105630956
版权

MySQL中的排序ORDER BY 除了可以用ASC和DESC，还可以自定义字符串/数字来实现排序

如果遇到null或者没有在结果集上存在的数据，则返回0，然后根据升序进行排序

ppzys
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
PHP中ORDER BY子句的详细用法教程
01-19
我们已经看到SQL SELECT命令来获取数据从MySQL表。当选择行，MySQL服务器是自由返回，除非指示说如何排序结果否则它会自由返回。指定需要结果集增加一个ORDER BY子句要作为排序依据的列或列名进行排序。 语法: SELECT field1, field2,...fieldN table_name1, table_name2... ORDER BY field1, [field2...] [ASC [DESC]] 这里是通用的SQL的SELECT命令的语法，ORDER BY子句从MySQL表中的数据进行排序：     您可以根据返回的结果的任何字段，提交将被列出。   
Self-deflection of bright soliton in a separate bright-dark screening soliton pair based on higher-order space charge field
02-11
Based on the interaction of the separate soliton pair, the self-deflection of the bright screening soliton in a bright-dark pair is studied by taking the higher order space charge field into account. Both numerical and analytical methods are adopted to obtain the result that the higher order of space charge field can enhance the deflection process of the bright soliton and varying the peak intensity of the dark soliton can influence the self-deflection strongly. The expression of the deflection
cisco_router_performance_field_guide.zip
08-22
Introduction When I started this project, I had two requirements and I strived throughout the book to balance both of them. My first requirement comes from being an instructor and consultant for 10 years now. In that time, I have found a consistent void with most of my students and clients. It is not that clients are unwilling to implement new technologies. It is not that students are unable to learn about new technologies. The void is between those two. You learn about new technologies, but often the knowledge you gain does not provide a solid understanding of where in the network the new technology resides. You get design models, learn commands to turn features on and off, but you don’t know where to locate the device or why to implement a particular application or feature. For this reason, I have written this book in the form of a single case study that runs through the entire book. The case study revolves around a single, fictitious company that I created for the sole purpose of explaining where and why technologies should be placed in a real network. I hope that they do not become just objectives in a book for you to memo- rize. The Real World Scenarios are designed to trigger your thought process and allow you to find practical applications in your own networks. Speaking of objectives, this brings me to the second requirement for the book. That requirement is to fill a hole in having a single source of information, a place to learn about all of the common technologies used by network engineers today. To provide an outline for those common technologies, I used the objectives in place as of January 2009 for the Cisco Certified Network Professional (CCNP) certification. It would be difficult to cover every single objective from this certification track in one book, but you will find I have covered a vast majority of the objectives. My hope is that you will find this book a valuable supplemental guide in your studies as you endeavor to attain the coveted CCNP certification. The challenge was getting as many technologies into the book with enough detail so you would to know where and how to use them. There is not enough room in a single book to cover every possible solution or every single command and option you could use to accomplish a task. I do recommend some of the best and most common ways to accomplish the tasks. On that note, I hope that my coverage of wireless technologies in the last two chapters of the book will pique your interest in the exciting new technologies in wireless LANs. If you want a more in-depth fundamental look at how wireless networks operate and all of the fun, new toys (I mean wireless devices) that you can use to implement them, then watch for the new CCNA wireless book that Todd Lammle and I are currently writing for Sybex. Who Should Read This Book I highly recommend to anyone reading this book to have their CCNA certification or a firm understanding of the objectives and concepts covered. I put so many technologies into this one book, and covered as much of the CCNP material as possible that I didn’t have the space required to review all of the CCNA material. 83605book.indd 25 3/26/09 11:26:31 AM xxvi Introduction How to Use This Book This book not only covers many exciting and complex networking topics but shows you the steps required to design a full corporate internetwork. If you follow the chapters in order, I walk you not only through building single VLANs and subnets but through the security, voice, QoS, and wireless technologies you need to implement an entire campus network. How This Book Is Organized In Chapter 1, I provide for you an explanation of Cisco’s current design methodologies. This includes a discussion on Cisco’s Enterprise Composite Design Model and how that model has evolved over the years. Even a little bit about where it may go in the future. Following the design section of Chapter 1, I break down for you in detail what you can expect to accomplish in each chapter of the book and explain why I organized the book the way I did. After that, I describe for you the case study that is the framework for the book. This includes background of FutureTech, Inc., the network layout that the company has, and the technologies you are going to implement over the course of the book. You will be acting as the senior network engineer for the company (or the highly paid expert consultant that helps them through the process, if that sounds better to you). The last thing that I cover in Chapter 1 is the equipment and lab setup you can use to test and practice the technologies and topics you go through in the book. I will give you a breakdown of the topology that I will be using and supplemental equipment that can be used in exchange for the equipment that I have in my setup. With those details out of the way, I jump right into helping you build your network. Chapter 2 provides the lowdown on switching. Here you get a look at Layer 1 and Layer 2 functionality and access layer devices, creating a strong foundation from which to build the rest of the network. Then, I get into some Layer 3 functions with inter-VLAN routing. In Chapter 3, I walk you through controlling the topology and your connections. By the time you’ve finished Chapter 3 you will understand all of the functions of STP and how it prevents broadcast storms, multiple frame copies, and protects the stability of the MAC address table. In Chapters 4 through 7, you learn specifically about the routing process itself and how to give routers the information they require. I cover both static and dynamic routing protocols in depth, along with ways to filter and control the propagation of routing information between routers and routing domains. I also provide you with the means to verify and troubleshoot your network connections. Chapters 8 through 10 teach you about protocols and functions that make your net- work more reliable and efficient. In Chapter 8, I cover multicast. Here you learn what makes multicast work and see some of the configurations available to help you cope with increased use of applications and programs that send large amounts of data to a whole group of users. Continuing in this vein in Chapter 9, I give you the nuts and bolts of Inter- net Protocol version 6 (IPv6). In Chapter 10, I show you how to provide redundancy and load balancing features to your network using just your routers. You learn to configure and use HSRP, VRRP, and GLBP
Fast magnetic energy dissipation in relativistic plasma induced by high order laser modes
02-07
Fast magnetic field annihilation in a collisionless plasma is induced by using TEM(1,0) laser pulse. The magnetic quadrupole structure formation, expansion and annihilation stages are demonstrated with 2.5-dimensional particle-in-cell simulations. The magnetic field energy is converted to the electric field and accelerate the particles inside the annihilation plane. A bunch of high energy electrons moving backwards is detected in the current sheet. The strong displacement current is the dominant
Attosecond twisted beams from high-order harmonic generation driven by optical vortices
02-07
Optical vortices are structures of the electromagnetic field with a spiral phase ramp about a point-phase singularity, carrying orbital angular momentum (OAM). Recently, OAM has been imprinted to short-wavelength radiation through high-order harmonic generation (HHG), leading to the emission of attosecond twisted beams in the extreme-ultraviolet (XUV) regime. We explore the details of the mapping of the driving vortex to its harmonic spectrum. In particular, we show that the geometry of the harm
mysql 查询结果集排序 order by field()
xiaolv7788的博客
09-06 738
window.openopen() 方法用于打开一个新的浏览器窗口或查找一个已命名的窗口。 或者下载文件 当按钮方法直接出发时几乎没有问题
MySql自定义排序 order by field()
分享不仅为了他人，同时也为了自己
02-24 1万+
前言 MySQL中 order by 自定义值排序 项目场景： 数据库表中有一个 status 字段，表示各个状态值，如下 smallint DEFAULT NULL COMMENT '项目状态(0 未发布，1 即将开始，2 拍卖中，3 拍卖结束-成功拍出，4 拍卖结束-流拍) 问题描述： 在查询列表时，要求：根据状态排序 拍卖中 > 即将开始> 拍卖结束-成功> 拍卖结束-流拍> 未发布的顺序去执行。 而我们常见的排序语法为：order by statu...
order by FIELD 及其平替函数 的用法
小羊的博客
05-17 2912
该文章主要介绍MySQL中常用于排序的函数order by FIELD，以及其他类似函数如FIND_IN_SET和CASE WHEN。order by FIELD可以按照指定顺序对结果集进行排序，而FIND_IN_SET可以在字符串列表中查找指定的值并返回其位置，进而实现按照指定顺序排序。CASE WHEN语句也可以实现按照指定条件进行排序。根据实际需求选择合适的语句可以达到最佳的查询效果。
MySQL自定义排序ORDER BY FIELD()
热门推荐
Crayon
06-24 5万+
MySQL中的排序ORDER BY 除了可以用ASC和DESC，还可以自定义字符串/数字来实现排序。格式如下：SELECT * FROM table ORDER BY FIELD(status,1,2,0);这样子写的话，返回的结果集是按照字段status的1、2、0进行排序的，当然，也可以对字符串进行排序。原理如下：FIELD()函数是将参数1的字段对后续参数进行比较，并返回1、2、3等等，如果...
order by field()使用场景
incredible1024的博客
04-16 765
ORDER BY FIELD() 是一种对查询结果排序的方法，它可以根据指定的字段值顺序进行排序。在 ORDER BY 子句中使用 FIELD() 函数可以指定一个表达式和一个可选的值列表，然后按照值列表中的顺序进行排序。
MySQL自定义排序：多列自定义排序 order by field（）
走在搬砖的路上！
04-23 5354
Mysql自定义排序 order by+field（） 语法： 自定义排序 +多字段排序 ORDER BY FIELD(`STATUS`,'1001','1002','1003') desc, ADD_DATE desc 单个字段降序 /升序 排序： select * from table order by id desc; select * from table order b...
mysql order by field自定义排序
ahjxhy2010的博客
06-28 624
语法 ORDERBYFIELD(`id`,5,3,7,1) 要注意的是,FIELD 后面是没有空格的. 因此, 完整的 SQL 为: SELECT*FROM`MyTable` WHERE`id`IN(1,7,3,5) ORDERBYFIELD(`id`,5,3,7,1) 常见应用 SELECT*FROM`MyTable` WHERE`name`IN('张三','李四','王五','孙六') ORDERBYFIE...
【MYSQL 按照固定值进行排序 order by field()】
A_guilei的博客
12-19 2092
（1）在MySql中，使用 ASC 或 DESC 关键字来设置查询结果是按升序或降序排列。（2）尤其非常特别重要：默认按升序（ASC）排列。（3）order by 后可加2个（或多个）字段，字段之间用英文逗号隔开。（4）若A用升序，B用降序，SQL该这样写：order by A ASC, B DESC;默认同理，也可以这样写：order by A, B DESC;（5）若A、B都用降序，必须用两个DESC，order by A DESC, B DESC;
MySQL 自定义排序函数 order by field()
Yuno
02-11 1321
在开发工作中,经常会用到查询.常用的ASC、DESC通常不能满足我们对查询数据的排序  order by field() MySQL提供的一个自定义排序函数: select * from table order by field(status,"success","fail");这里是表示结果集按照字段status是"success","fail"的顺序排序,如果status存在其它结果,则排...
mysql使用orderby field
文盲青年的博客
04-12 1128
MySQL中的排序ORDER BY 除了可以用ASC和DESC，还可以自定义字符串/数字来实现排序。 示例1： ... order by field(value,str1,str2,str3,str4,,,strn) select * from score order by field(level,'A','B','C','D'); 示例2： SELECT * FROM table ORDER BY FIELD(status,1,2,0); 这样子写的话，返回的结果集是按照字段status的1、2、0
Mybatis 中 order by 排序失败的解决方法
rainbow702的博客
12-28 1万+
在 mybatis 的 xml中，为一个SQL语句配置order by 子句时，需要这个排序的字段是前端传递过来的，而且排序的顺序（升序 OR 降序）也是由前端传递过来的。对于这种需求，我起初写成了下面这样：ORDER BY `#{condition.field}` #{condition.sortRule}然后，预计它的输出应该是类似于下面这样的ORDER BY `user_name` DESC但
order by FIELD 字段自定义排序
weixin_44805962的博客
12-29 291
order by FIELD( f.order_status ,1, 3,0,2,4),f.send_time
MySQL或Oracle按照自定义顺序进行排序语法 ORDER BY
ZHAIKE的博客
05-23 1746
场景 in查询，并且需要按照 IN 内元素的顺序进行显示 / 返回 MySQL 关键字 FIELD ORDER BY FIELD( fieldId, 90, 89, 92, 91 ) Oracle 关键字 DECODE，并且需要指定顺序1，2，3，4… ORDER BY DECODE( FIELDID, 92, 1, 89, 2, 90, 3, 91, 4 ) ...
ORDER BY FIELD
最新发布
07-28
ORDER BY FIELD() 是一种对查询结果排序的方法，它可以根据指定的字段值顺序进行排序。在 ORDER BY 子句中使用 FIELD() 函数可以指定一个表达式和一个可选的值列表，然后按照值列表中的顺序进行排序。例如，可以使用...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值