SQLite 3.16

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

create table tab1 (fld1 text);
insert into tab1
values
('ABC_IDX_TST_01'),
('XYZ_IDX_TST_02'),
('XYZ_IDX_TST_03')
;
select *
from tab1
where fld1 LIKE '%IDX_TST%'


fld1


ABC_IDX_TST_01

XYZ_IDX_TST_02

XYZ_IDX_TST_03