Introduction to the use of Find_in_set in Mysql _mysql

Use examples:

A field (purview) in the user table represents the user's permissions

Save all of the user's permission IDs in this field. For example, there are five privileges such as 1,2,3,4,5

Find out which users have permissions with a permission ID of 1

Copy Code code as follows:

SELECT * from user where find_in_set (' 1 ', purview);

SQL statement

SQL Explanation: Find out all the information for all users with 1 of this permission.

The purpose of this design data table is to reduce the number of tables, but it will increase the difficulty of the update!