Skip to main content
Journey Uncommon Logo
JourneyUncommon
mediumSQLJSONB queryingSingle-choice MCQ

Which operator tests whether a JSONB value contains a given JSON structure, and is supported by a GIN index for fast lookups?

-- Find rows whose tags JSONB contains {"role": "admin"} SELECT * FROM users WHERE tags @> '{"role": "admin"}';