[GENERAL] How to search a string inside a json structure

[Sami Pietilä]

Hi,

I have a database with jsonb type of columns. Colums contain complex json
structures. I would like to get all rows which contain a json where any of
json's values matches to a given string (like %hello%).

How to create a postgre sql query to do this?

I guess postgre should traverse though each json structures while finding
the string.

Thanks