MySQL Find_in_set function use method sharing _php Tutorial

There are times when we are designing a database, such as:

There is a Type field in the article table, he stores the article type, there are 1 headlines, 2 recommended, 3 hot, 4 graphics ..... 11,12,13, wait.

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 texts in the type,

It's time for our find_in_set to come.

First look at the syntax of the Find_in_set function in the MySQL manual:

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 string of self-chains that are separated by ', ' 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 (', ').

Copy CodeThe code is as follows:
mysql> SELECT find_in_set (' B ', ' a,b,c,d ');
2

It's easy to use.

Let me give you an example of what I said above:

The following is the referenced content:
Copy CodeThe code is as follows:
SELECT * from article where Find_in_set (' 4 ', type)

http://www.bkjia.com/PHPjc/325196.html www.bkjia.com true http://www.bkjia.com/PHPjc/325196.html techarticle There are times when we design a database, for example: There is a Type field in the article table, he stores the article type, there are 1 headlines, 2 recommendations, 3 hotspots, 4 graphics ..... 11,12,13, etc. ..

