Easy SELECT & filtering Free

SQL interview question: Search by Name Pattern With LIKE

Search Products by Name Pattern

The search team is testing a feature to find all products with 'Pro' in their names.

Find all products whose name contains 'Pro' (case-insensitive).

Return product_id, product_name, and price.

Skills: LIKE pattern matching and wildcards

Tables

products 20 rows
  • product_id integer PK
  • product_name text
  • category text
  • price real
  • rating real
product_idproduct_namecategorypricerating
1MacBook ProElectronics1999.994.8
2iPad AirElectronics599.994.8
3AirPods ProElectronics249.994.7
About the e-commerce sample database

Practice on your iPhone

Query Dojo for iPhone has 85 interview questions, timed mock interviews and a tile builder, so you can write queries without a keyboard.

Get the app

Keep going