[ad_1]
I have table in Postgres with JSONB filed.
JSONB contains jsons as:
{
"id": "adf59079-4921-4abc-a262-1dc8c2b1ccc7",
"lastname": "LOBATOS",
"firstname": "Leslie",
"birth_date": "1988-01-26",
"gender": 3,
"contacts": {
"phoneList": [
{
"fullNumber": "0671234567",
"verifyStateId": 1
},
{
"fullNumber": "0671234588",
"verifyStateId": 0
}
]
}
}
I need select following data-set (in SQL notation)
SELECT id, lastname, fullNumber FROM <JSONB-field>
WHERE fullNumber LIKE '067%' and verifyStateId = 1
Plz help write query
[ad_2]