[Solved] Which of the following is the correct syntax to check if a JSONB column data contains the JSON {"key": "value"}?SELECT * FROM table WHERE data ___ '{"key": "value"}'::jsonb; | PostgreSQL

PostgreSQL - JSON and JSONB

Which of the following is the correct syntax to check if a JSONB column data contains the JSON {"key": "value"}?

SELECT * FROM table WHERE data ___ '{"key": "value"}'::jsonb;

A@>

B<@

C->

D->>

Step-by-Step Solution

Solution:

Step 1: Identify the containment operator
The @> operator checks if the left JSONB contains the right JSONB.
Step 2: Apply correct syntax
To check if data contains the JSON, use data @> '{"key": "value"}'::jsonb.
Final Answer:
@> -> Option A
Quick Check:
Containment operator = @> [OK]

Quick Trick: Use @> with right side cast to jsonb [OK]

Common Mistakes:

Master "JSON and JSONB" in PostgreSQL

9 interactive learning modes - each teaches the same concept differently

Which of the following is the correct syntax to check if a JSONB column data contains the JSON {"key": "value"}?