Split a string into separate columns in MySQL

How can we split a string similar to below example based on delimiter ‘,’ in MySQL?
I want the splitted substrings into separate columns or rows. This can be easily done in SQL using
SPLIT_FUNCTION() but in MySQL there is no such function.
I have tried SUBSTRING_INDEX(). But it is giving only 1 substring based on delimiter index

Given input string:

Expected output:
Column 1: Adam, Column 2: John, Column 3: Eve, Column 4: Jack

Or output in separate rows: