1. 学习
    2. /
  2. 课程
    3. /
  3. Functions for Manipulating Data in PostgreSQL
Connected

练习

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.