How to split delimited column and query other table using the split value.

[Satyababu Mavireddy]

I am new to MYSQL, I am looking for ideas and if possible code block for my requirement below.
I need to split the values mentioned in ‘T2_IDs ‘in T1, and query T2 for each T2_Id produce the result set
I have googled and read through MY SQL documentation for appropriate functions, it seems there is no such function which can be used to convert delimited column value into list, so that it can be used with IN ()
I have tried some of the function posted in blogs, they all working but not fetching the results as required.
Table 1: T1

Id T2_ids

1 10;11
2 11;12;10


Table2 :T2

Id title

10 Abcd
11 Edf
12 Def

Expected Output:

Id title

1 Abcd
1 Edf
2 Edf
2 Def
2 Abcd

Any help is much appreciated.