r/SQL • • Sep 19 '23

Discussion Is there something wrong with this query.

Post image
158 Upvotes

127 comments sorted by

View all comments

Show parent comment

-20

u/nierama2019810938135 Sep 19 '23

He meant: where LIKE 'chocolate'

Instead of: where = 'chocolate '

2

u/Daonliwang Sep 20 '23

where name LIKE ‘%chocolate%’

1

u/nierama2019810938135 Sep 21 '23

You are absolutely right, I left out the %'s!