By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
with t as (
select '1,2,1' as mycsv, 5 as myval
union all select '35,55,15', 5
union all select '5', 5
union all select '0,5,1', 5
)
select t.*, ',' || mycsv || ',' like '%,' || myval || ',%' as found
from t
| mycsv | myval | found |
|---|---|---|
| 1,2,1 | 5 | 0 |
| 35,55,15 | 5 | 0 |
| 5 | 5 | 1 |
| 0,5,1 | 5 | 1 |