Practice · easy · dataset: ecom

Product name prefix search

A search box needs to match product names that start with the text Product 1. Return every matching product with its id, name, and unit price, sorted by product_id ascending.

Use a pattern match rather than listing the ids you expect. The result should include any product whose name begins with that prefix, regardless of how many digits follow it.

Tables available

Table Columns
products product_id, name, category, unit_price
⌘/Ctrl + Enter to grade

Write a query, then grade it.

Hints

Try it first. Reveal a hint only when you are stuck.