How to search a string inside a json structure

[Sami Pietilä <sami.pietila@xxxxxxxxx>]

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