mysql - How To Seperate the record values in sql -

mysql - How To Seperate the record values in sql -

i have sql table below

classids

2,3,4,5, 2,4,5,6, 5,9,6,8,

i want split comma separated values in sql

i want give status

select classids table name classids = 2

use regular expressions below

select classids table classids regexp '\b2\b'

mysql sql