MySQL - Split a string where substring is found

select 
   SUBSTRING_INDEX('part 1, part 2', ',', 1) as part_1
   , SUBSTRING_INDEX('part 1, part 2', ',', -1) as part_2
;