MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE a (id CHAR(4), name VARCHAR(255));
INSERT INTO a VALUES
('P001', 'Samsung'),
('P002', 'Nokia'),
('P003', 'Oppo');

CREATE TABLE b (id INT, value VARCHAR(255));
INSERT INTO b VALUES
(1, 'P001,P002,P003'),
(2, 'P001,P002, P003');

Records: 3  Duplicates: 0  Warnings: 0



Records: 2  Duplicates: 0  Warnings: 0


SELECT b.id, GROUP_CONCAT(a.name) value
FROM a
JOIN b ON FIND_IN_SET(a.id, b.value)
GROUP BY b.id;


id
value


1
Samsung,Nokia,Oppo

2
Samsung,Nokia


SELECT b.id, GROUP_CONCAT(a.name) value
FROM a
JOIN b ON FIND_IN_SET(a.id, REPLACE(b.value, ' ', ''))
GROUP BY b.id;


id
value


1
Samsung,Nokia,Oppo

2
Samsung,Nokia,Oppo