MySQL string function find_in_set () Two-point usage

Summary: You can query the fields separated by commas and force the sorting of the results.

First look at a table:

Area

colid	Vyear		cast
, 31,32,21,12	2014	1	15
, 32,33,34,35,21,	2014	2	16
, 33,34,36,39,40	2011	3	17

The value of the Colid field in the table is separated by commas,

When we need to query this table, Colid contains 32 rows,

Then you can use Find_in_set ()

SQL is as follows:

SELECT * FROM table WHERE find_in_set (' + ', colid);

A forced sort can be written like this:

Select*fromtablewherearea in (2,1,3) ORDER         by Find_in_set (area, ' 2,1,3 ');