LIKE Pattern Matching
Beginner
Your search feature lets support staff find users by email domain. Return everyone whose email address ends with @example.com. Addresses such as carol@example.com.au (a different domain) and erin@notexample.com must not be matched. SQLite's LIKE ignores case for ASCII letters, so dave@EXAMPLE.COM does count.
Write a query returning all columns of users whose email ends with '@example.com'.
Constraints
- Return all columns
- The address must end with
@example.com - Match case-insensitively (the default for SQLite's
LIKE)
Hints
Hint 1
% in a LIKE pattern means "any characters".
Hint 2
Put the % at the start of the pattern so only the ending is fixed.
Keywords
db
SQL
Run your code to see results
No results yet
Run your code to check it against the examples, or submit to run every test.