Splitting Comma-Separated Values In MySQL

CREATE TABLE numbers (n INT);
 INSERT INTO numbers VALUES
(1),
(2),
(3),
(4),
(5),
(6),
(7),
(8),
(9),

 

 

select 
  id, 
  substring_index(
    substring_index(email_recipients, ',', n), 
    ',', 
    -1
  ) as email
from dashboards
join numbers
  on char_length(email_recipients) 
    - char_length(replace(email_recipients, ',', '')) 
    >= n - 1

 


Reference Site : https://www.sisense.com/blog/splitting-comma-separated-values-in-mysql/