select id, name from table where name ilike all(string_to_array(replace('%'||TRIM('JOHN DOE')||'%',' ','%,%'), ',')) -- 1) it converts spaces into commas (,) -- 2) it converts string to array using resulting comma separated string -- 3) it apply ilike to each word in search string -- It finds (for example) name = 'DOE, JHON' in table
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