1. เรียนรู้
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in PostgreSQL
Connected

Exercises

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.

คำแนะนำ

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