How to split field and run sub query using it?

0 votes

1 answer

128 views

                          Given two tables T1 and T2 below, is there a way in MySQL 5.7.x to get such a list field from T1, so that none of its entries are present in T2?
T1.list is a regular VARCHAR, containing T2.vals delimited by ':'

From the example, I would like to get D:E field.

T1
    
    id list
    0  A:B:C
    1  D:E
    2  F:G

T2

    vals
    A
    B
    C
    F
    G
                        

Asked by Ninius86 (103 rep)

Jan 17, 2020, 10:55 AM
Last activity: Jan 17, 2020, 12:03 PM

How to split field and run sub query using it?

Related Questions