How to search table records by JSONB type field?

Question

PostgreSQL

There is Laravel 7 and PostgresSQL 11 DBMS. It has a users table . The users table has a contacts field of type JSONB . The data structure in the contacts field is as follows:

{
    "phones": [
        { "value": "89999999999" },
        { "value": "81111111111" }
    ]
}

Is it possible to search for a record by value field using whereJsonContains ? If not, how can the problem be solved?

Answer 1

SELECT * FROM table where data->'phones' @> '[{"value":"81111111111"}]'