CREATE TABLE GVTEMP
TRUNCATE TABLE GVTEMP;
INSERT INTO GVTEMP VALUES (1,'MYABC');
INSERT INTO GVTEMP VALUES (2,'MYXYZ');
SELECT * FROM GVTEMP;
SELECT * FROM GVTEMP WHERE X LIKE ('%ABC%,%XYZ%');
how can I select both the rows with a single select using like operator ?