How to Use find_in_set in MySQL

Example:

A field (purview) in the User table represents the permission of the user.

Store all user permission IDs in this field. For example, you have five permissions: 1, 2, 3, 4, and 5.

Find which users have the permission Id 1

CopyCodeThe Code is as follows: Select * from user where find_in_set ('1', purview );

SQL statement

SQL explanation: find information about all users with the 1 permission.

In this way, the purpose of designing a data table is to reduce the number of tables, but it will increase the difficulty of updating!