select distinct col1,col2,col3 from ( select col1,A as col2,B as col3 from tb where B like '%FF%' union all select col1,C as col2,D as col3 from tb where D like '%FF%' )T
select * from tt where find_in_set('FF',B)>0 OR find_in_set('FF',D)>0
select A,B from table1 where find_in_set('FF',B) union all select C,D from table1 where find_in_set('FF',D)
from
(
select col1,A as col2,B as col3 from tb where B like '%FF%'
union all
select col1,C as col2,D as col3 from tb where D like '%FF%'
)T
from table1
where find_in_set('FF',B)
union all
select C,D
from table1
where find_in_set('FF',D)
find_in_set真是个好函数啊~