Two-Point usage of Mysql string function FIND_IN_SET ()

Two-Point usage of Mysql string function FIND_IN_SET ()

Summary: You can query fields separated by commas and forcibly sort the results.

First, let's look at a table:

Colid	Vyear	Area	Cast
, 31,32, 21,12	2014	1	15
, 32, 33, 34, 35, 21,	2014	2	16
, 40	2011	3	17

The values of the colid field in the table are separated by commas,

When we need to query this table, the colid contains 32 rows,

You can use FIND_IN_SET ()

The SQL statement is as follows:

SELECT * FROM table WHERE FIND_IN_SET ('32', colid );

The following can be written for forced sorting:

SELECT * FROMtableWHEREarea IN (2, 1, 3) order by find_in_set (area, '2, 3, 3 ');