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.