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.