select *
from ttt
where (substr(substr(code, length(code) - 4 + 1, 4),1,2) =substr(substr(code, length(code) - 4 + 1, 4),3,2)
or (substr(substr(code, length(code) - 4 + 1, 4),1,1) =substr(substr(code, length(code) - 4 + 1, 4),2,1)
and substr(substr(code, length(code) - 4 + 1, 4),3,1) =substr(substr(code, length(code) - 4 + 1, 4),4,1)))
and substr(substr(code, length(code) - 4 + 1, 4),1,1) in ('6','8','9')
and substr(substr(code, length(code) - 4 + 1, 4),4,1) in ('6','8','9')
from ttt
where (substr(substr(code, length(code) - 4 + 1, 4),1,2) =substr(substr(code, length(code) - 4 + 1, 4),3,2)
or (substr(substr(code, length(code) - 4 + 1, 4),1,1) =substr(substr(code, length(code) - 4 + 1, 4),2,1)
and substr(substr(code, length(code) - 4 + 1, 4),3,1) =substr(substr(code, length(code) - 4 + 1, 4),4,1)))
and substr(substr(code, length(code) - 4 + 1, 4),1,1) in ('6','8','9')
and substr(substr(code, length(code) - 4 + 1, 4),4,1) in ('6','8','9')
select code,
substr(substr(code, length(code) - 4 + 1, 4), 1, 1) col1,
substr(substr(code, length(code) - 4 + 1, 4), 2, 1) col2,
substr(substr(code, length(code) - 4 + 1, 4), 3, 1) col3,
substr(substr(code, length(code) - 4 + 1, 4), 4, 1) col4
from tttt)
where ((col1 = col2 and col3=col4) or (col1 = col3 and col2=col4))
and col1 in ('6','8','9')
and col4 in ('6','8','9')