MySQL query for finding values in a comma separated string

MySQL query for finding values in a comma separated string. Use REGEXP feature in your MySQL query for finding value in comma separate string. Given example query can use for find given value/values in comma separated string.

Here is example given for finding values from multiple comma separate string. By this REGEXP you can search one or more ids in string.

MySql table:

sport_activity

id    activity
---   --------
 1    Cricket
 2    Hockey
 3    Football
 .    .
 .    .
 60   Chess

student

id    sport_ids
---   ---------
 1    1,4,3,6,10
 2    1,3,50
 3    25
 .    .
 .    .
 60   3,5,6,47

Example 1: Find single id in comma separated string
(Get all student id who plays Football)

SELECT id FROM student WHERE sport_ids REGEXP "[[:<:]](3)[[:>:]]"

Example 2: Find multiple id in comma separated string
(Get all student ids who plays Cricket,Football,Chess)

SELECT id FROM student WHERE sport_ids REGEXP "[[:<:]](1|3|60)[[:>:]]"

How to use this REGEXP:
{field_name} REGEXP “[[:<:]]({id_list})[[:>:]]”
{field_name} = Field name that contains comma separate values
{id_list} = pipe separated id list, that we need to find in string