String contains contraction


I am doing Davies Burgers Ad from Analyze with SQL. Was trying to do challenge 10 and realized that my query did not work with contraction. Could you help me modify if there is anything wrong?

SELECT item_name, restaurant_id, user_id, special_instructions
FROM orders
WHERE special_instructions LIKE ‘%don’t%’;

Thanks in advance!

Not 100% sure on the formatting there but make sure your string isn’t closing early with the apostrophes you’re using for punctuation getting mixed up with the string notation.

1 Like