Databases SQL Basics Finding the Data You Want Finding Data that Matches a Pattern

SQL %

In the e-commerce database we have a products table. The columns are id, name, description and price.

Find all the products where the pattern 't-shirt' can be found anywhere in the product name.

I wrote this code but it says is wrong

SELECT * FROM products WHERE description LIKE "%t-shirt%";

1 Answer

Steven Parker
Steven Parker
176,365 Points

You're close, but the instructions ask you to find the pattern "anywhere in the product name" (not description).

thanks a lot