By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with cte1 as
(
select 1 as id, 'CHAN TAI MAN' as names
union all
select 2, 'CHAN SIO LONG LEI TAI MAN'
union all
select 3, 'LEI CHAN TAI MAN'
)
select * from cte1
where names like '%LEI%TAI%MAN%'
| id | names |
|---|---|
| 2 | CHAN SIO LONG LEI TAI MAN |
| 3 | LEI CHAN TAI MAN |