Postgres query inside a json Field

Hi All

I need to get some data out of our phone system. All the calls are written to the database and the json field which contains the data I need.

Can anyone advise how I would do a db search in the json field for all the "digits_dialed": "2"

I can do the normal select * from v_xml_cdr for basic stuff but this has me stumped as there is so much data in this field in each column

Thanks