---

select
    id,
    code,
    name
from back_office.operation_type
where name ilike '%выкуп%'
   or code ilike '%REDEMPTION%'
order by name, id;