What is the difference between in and find_in_set()?When to use them??

IN compares a column to a list of values.
FIELD_IN_SET compares a column or value to a column containing a list of values.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.