Get Started

Searching an ARRAY with @>

The contains operator @> operator is alternative syntax to the ANY function and matches data in an ARRAY using the following syntax.

WHERE array_name @> ARRAY['search text'] :: type[]

So let's practice using this operator in the exercise.

This is a part of the course

“Functions for Manipulating Data in PostgreSQL”

View Course

Exercise instructions

  • Use the contains operator to match the text Deleted Scenes in the special_features column.

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT 
  title, 
  special_features 
FROM film 
-- Filter where special_features contains 'Deleted Scenes'
WHERE ___ ___ ARRAY['Deleted Scenes'];
Edit and Run Code