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

[Vick Khera]

On Tue, Nov 3, 2015 at 10:07 AM, Sami Pietilä <sami.piet...@gmail.com>
wrote:

> Unfortunately I could not figure out how to select rows which, for
> example, contain following json: '{"a":"world","c":{"b":"helloworld"}}' by
> search with "hello" string.
>

cast the field to a text:

select * from t where myfield::text like '%hello%';