For example:
There is an article table with a Type field, which stores the article type, there are 1 headlines, 2 recommendations, 3 hotspots, 4 graphics ... 1,12,13 and so on.
Now there is an article he is a headline, but also hot, or graphic,
The type is stored in 1,3,4 format .
So how do we use SQL to find all the 4 text standards in the type??
It's going to be ours. Find_in_set It's time to go.
The following is the referenced content:
SELECT * from article where Find_in_set (' 4 ', type)
----------------------------------------------------------
in the MySQL manual Find_in_set syntax for the function:
Find_in_set (Str,strlist)
If the string str is in a string list strlist consisting of N substrings, the return value ranges from 1 to N.
a list of strings is a number of ' , ' A string consisting of a separated strand of symbols. If the first argument is a constant string and the second is a type set column, the Find_in_set () function is optimized to use bit calculations.
If STR is not strlist or strlist is an empty string, the return value is 0. If either parameter is NULL, the return value is null. This function will not work correctly when the first parameter contains a comma (', ').
mysql> SELECT find_in_set (' B ', ' a,b,c,d ');
2 because B is placed at 2 in the Strlist collection starting from 1
--------------------------------------------------------
Select Find_in_set (' 1 ', ' 1 '); The return is 1. The Strlist collection is a bit special. Only one string actually requires the previous string to return a number greater than 0 in the next string collection.
Select Find_in_set (' 2 ', ' up '); Returns 2
Select Find_in_set (' 6 ', ' 1 '); Returns 0
----------------------------------------------------------
Attention:
SELECT * from TreeNodes where Find_in_set (ID, ' 1,2,3,4,5 ');
Return multiple records at once using the Find_in_set function
ID is a field of a table, and then each record is an ID equal to 1,2,3,4,5
Sort of like in (collection)
SELECT * from TreeNodes where ID in (1,2,3,4,5);
How to use the Find_in_set function of MySQL