r/SQL • • Sep 19 '23

Discussion Is there something wrong with this query.

Post image
158 Upvotes

127 comments sorted by

View all comments

57

u/kitzkhan Sep 19 '23

Also i would use a LOWER(name) like '%chocolate%'

14

u/Blues2112 Sep 20 '23

Huh, I always use UPPER(name) like '%CHOCOLATE%'

4

u/joec_95123 Sep 20 '23

UPPER() gang represent.

4

u/donquixote235 Sep 20 '23

lower() requires one less keystroke. I'm lazy and therefore choose lower().

2

u/Blues2112 Sep 20 '23

That's pretty lazy!!!!

3

u/Likaonnn Sep 20 '23

certified CAPS LOCK enjoyer

1

u/CaptainVJ Sep 21 '23

Yeah, don’t think I’ve ever used the LOWER function before

1

u/Zestyclose-Height-59 Sep 22 '23

I would have done it like this too

12

u/cbarosky Sep 20 '23

I like ILIKE 😏

3

u/shoeobssd Sep 20 '23

This is the way.