select * from mastars.table_name WHERE column_name = ‘xyz’ AND
(CAST(jsonb_values(column_name) AS TEXT) ~ ‘^9074309’) limit 5;
regex pattern- ^9074309′
jsonb column data
{ "alarm":{ "oc": ".OC.APOLLO_VSM", "msa": "", "city": "", "gsam": "", "note": "", "text": "", "tsys": "", "cause": "samsungUSM_5599460-5G", "state": "OUTSTANDING", "domain": "VSM", "region": "", "status": "NOT_HANDLED", "vendor": "", "ackUser": "", "alarmId": "9074309", "severity": "CRITICAL", "termUser": "", "alarmType": "Network", "billingId": "", "circuitId": "", "clearFlag": false } }
Expecting regex pattern should match with beginning of the letters with ^ symbol.
Ritika Gupta is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.