RivoCode

SQL Fundamentals · Filtering & Sorting · Lesson 9 of 17

Pattern Matching with LIKE

Concept

Pattern Matching with LIKE

LIKE finds rows matching a text pattern, where % matches any sequence of characters and _ matches a single character.

By the end of this lesson
  • Explain the core idea behind Pattern Matching with LIKE.
  • Predict output before running a change.
  • Test one realistic and one unusual input.
  • Use the result to make the next decision.
How to study this page
  1. 1. Read one concept.
  2. 2. Change the example.
  3. 3. Run, compare, and explain.
  4. 4. Complete the challenge below.
ExampleRunnable
SELECT * FROM students
WHERE name LIKE 'A%';
Try it Yourself »
Self-check before continuing

Without looking at the example, describe what changes when you modify one input in Pattern Matching with LIKE. Then reopen the editor and prove your explanation with a small test.

You are ready to continue when you can predict, test, and explain the result.

Your turn

Write a query that finds all students whose name ends with the letter n.

Loading editor…

Console

Output will appear here...