Detailed discussion of the character order of mysql order by in (recommended)

//MySQL statement SELECT * FROM `MyTable` WHERE `id` IN (11,1,111) ORDER BY FIELD(`id`, 11,1,111);

Laravel Framework

$ids = array(1,17,2);

$ids_ordered = implode(',', $itemIds);

$items = static::whereIn('id', $ids)->orderByRaw(DB::raw("FIELD(id, $ids_ordered)"))->get();

The above article discusses the character sequence of mysql order by in (recommended) in detail. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.

You may also be interested in:

MySQL Order by statement usage and optimization detailed explanation
In-depth analysis of the order by and group by sequence issues in MySQL
How to use union and order by at the same time in MySQL
MySQL Order By Syntax Introduction
MySQL Order By Index Optimization Method
MySQL order by performance optimization method example
MySQL Order By Multi-Field Sorting Rules Code Example
Implementation analysis of MySQL ORDER BY
MySQL Order By Rand() Efficiency Analysis
Summary of three ways to implement ranking in MySQL without using order by

Detailed explanation of installation and configuration of Redis and phpredis extension operation in Ubuntu 18.04 system

Blog

Detailed discussion of the character order of mysql order by in (recommended)

How to implement responsive layout in vue-cli

Problems with changing password and connecting to Navicat when installing and using MySQL 8.0.16 under Windows 7

Detailed explanation of installation and configuration of Redis and phpredis extension operation in Ubuntu 18.04 system

JavaScript canvas to achieve scratch lottery example

Detailed analysis of GUID display issues in Mongodb

Markup Language - Print Style Sheets

Several reasons for not compressing HTML

Two ways to implement square div using CSS

Markup Language - Title

Summary of 11 common mistakes made by MySQL call novices

Recommend

Troubleshooting process for Docker container suddenly failing to connect after port mapping

Perfect solution to Google Chrome autofill problem

Explanation of using if judgment conditions in sum and count functions when using SQL statements to collect data

Zen coding resource update function enhancement

Docker image import, export, backup and migration operations

Detailed explanation of the pitfalls of MySQL 8.0

Implementation of Linux command line wildcards and escape characters

10 Popular Windows Apps That Are Also Available on Linux

Remote Desktop Connection between Windows and Linux

How to install mysql database in deepin 2014 system

Detailed tutorial on installing Anaconda3 on Ubuntu 18.04

Solve the conflict between docker and vmware

Learn MySQL execution plan

Table Tag (table) In-depth

Test and solution for MySQL's large memory usage and high CPU usage