--convert the phone data type into text to find specific numbers select *, case when phone::text ilike '435%' or phone::text ilike '%233%' or phone::text ~ '23' then 'yes' else 'no' end as test from x_csv as xc
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter