Only display specified values inside the IN clause with MySQL?
For this, you can use IN() along with ORDER BY clause. Let us first create a table −
mysql> create table DemoTable1986
(
Number int
);
Query OK, 0 rows affected (0.00 sec)
Insert some records in the table using insert command −
mysql> insert into DemoTable1986 values(50);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1986 values(60);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1986 values(100);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1986 values(200);
Query OK, 1 row affected (0.00 sec)
mysql> insert into DemoTable1986 values(350);
Query OK, 1 row affected (0.00 sec)
Display all records from the table using select statement −
mysql> select * from DemoTable1986;
This will produce the following output −
+--------+
| Number |
+--------+
| 50 |
| 60 |
| 100 |
| 200 |
| 350 |
+--------+
5 rows in set (0.00 sec)
Here is the query to show specified id inside the IN clause −
mysql> select * from DemoTable1986 where Number IN(50,100,350) order by field(Number,350,100,50);
This will produce the following output −
+--------+
| Number |
+--------+
| 350 |
| 100 |
| 50 |
+--------+
3 rows in set (0.00 sec)
Published on 31-Dec-2019 12:42:05
