SELECT *
FROM tbl
WHERE replace(data::text, ' ', '') LIKE '%foobar%';
and I think that's beautiful.
Treating
jsonb column as text via ::text is damn cool.
OL oleg_log @oleg_log · 1.73K subscribers SELECT *
FROM tbl
WHERE replace(data::text, ' ', '') LIKE '%foobar%';
jsonb column as text via ::text is damn cool.