icuba

LIKE 대신 SELECT INSTR('AAAA,BAA,CAA,DAA,AA', 'AAA') ;

FIND_IN_SET


SELECT FIND_IN_SET('AAA', 'AAAA,BAA,CAA,DAA,AA') ;

WHERE FIND_IN_SET(COLUMN_NAME, 'DATA1,DATA2');

http://www.ministory.net/xe/?mid=it_story&category=1598&document_srl=47355

• #INSTR
• #FIND_IN_SET