LIKE

Question

LIKE

You are having dinner at a restaurant and decide to order a chocolate dessert.
Here is the desserts menu:

Write a query to output only chocolate desserts.
Use the LIKE operator, and don't forget about "%".

Answer 1

SELECT *
FROM desserts
WHERE Name like'%checolate%'
order by price ASC;

Answer 2

JM Tyler Dylan Pineda did you try writing the query as they described? What was the result?

Answer 3

select * from suppliers
where city NOT IN ('london','Paris')
and status is not Null

Answer 4

Use LIKE '%Chocolate%'
statement for your program.