By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE tableA (id, mdn_list) AS
SELECT '1', 'Alice,Bobbi,Carol' FROM DUAL UNION ALL
SELECT '2', 'Andy,Bob,Charles' FROM DUAL;
2 rows affected
CREATE TABLE tableB (your_column) AS
SELECT 'Alice' FROM DUAL UNION ALL
SELECT 'Andy' FROM DUAL UNION ALL
SELECT 'Bobbi' FROM DUAL UNION ALL
SELECT 'Bob' FROM DUAL UNION ALL
SELECT 'Charles' FROM DUAL UNION ALL
SELECT 'Carol' FROM DUAL;
6 rows affected
SELECT *
FROM tableB
WHERE (SELECT ',' || mdn_list || ',' FROM tableA WHERE id = '1')
LIKE '%,' || your_column || ',%';
| YOUR_COLUMN |
|---|
| Alice |
| Bobbi |
| Carol |
SELECT *
FROM tableB
WHERE (SELECT ',' || mdn_list || ',' FROM tableA WHERE id = '2')
LIKE '%,' || your_column || ',%';
| YOUR_COLUMN |
|---|
| Andy |
| Bob |
| Charles |