1. Learn
    2. /
  2. Courses
    3. /
  3. Functions for Manipulating Data in PostgreSQL

Exercise

A review of the LIKE operator

The LIKE operator allows us to filter our queries by matching one or more characters in text data. By using the % wildcard we can match one or more characters in a string. This is useful when you want to return a result set that matches certain characteristics and can also be very helpful during exploratory data analysis or data cleansing tasks.

Let's explore how different usage of the % wildcard will return different results by looking at the film table of the Sakila DVD Rental database.

Instructions 1/3

undefined XP
  • 1

    Select all columns for all records that begin with the word GOLD.

  • 2

    Now select all records that end with the word GOLD.

  • 3

    Finally, select all records that contain the word 'GOLD'.