Selecting Subsets

• You can match patterns with LIKE
• The right-hand side is a string that can contain special characters
  • Special symbol _ matches exactly one character
  • Special symbol % matches any character sequence
• The expression to match all Name strings whose second character is an "o":

  Name LIKE '_o%'