Re: How to search a string inside a json structure

[Vick Khera <vivek@xxxxxxxxx>]

On Tue, Nov 3, 2015 at 10:07 AM, Sami Pietilä <sami.pietila@xxxxxxxxx> 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%';