How can we use FIND_IN_SET() function with MySQL WHERE clause?

I want to use MySQL FIND_IN_SET () function on the values stored in MySQL table. While using it, I also want to put some conditions on the data. I want to know that how I can use MySQL FIND_IN_SET () function with WHERE clause.

Hi, there are some examples on this page

Hi luanvanviet, not sure what data set are you working with, but here’s a simple example of how it will be to find the division that accepts red belt, you can use the FIND_IN_SET function as follows:

name, belts
FIND_IN_SET(‘red’, belts);

Let me know if that makes sense.