Q:

SELECT statement, value separate comma

I have the following:
Is this possible by sql query in MYSQL DB?  Or need php after result? 
thanks
name | date

test1 | 2019-01-01,2019-02-02,2019-03-03,2019-03-03

test2 | 2019-04-01,2019-05-01,2019-06-01,2019-07-01

And like to get:
name | date | 

test1 | 2019-01-01 |
test1 | 2019-02-02 |
test1 | 2019-03-03 |
test1 | 2019-03-03 |
test2 | 2019-04-01 |
test2 | 2019-05-01 |
test2 | 2019-06-01 |
test2 | 2019-07-01 |

A:

for this particular case you can give in hardcoded values:
select m.* from(select name,substring(date,1,10) as str
from table1
union all
select name,substring(date,12,10) as str
from table1
union all
select name,substring(date,23,10) as str
from table1
union all
select name,substring(date,34,10) as str
from table1)m order by m.name;

https://www.db-fiddle.com/f/xcRVMVV5qeh7J2BK1zMP4E/0

