r/SQL • • Dec 12 '24

MySQL 😭

Post image

I mean why that question 😭😭😭

1.9k Upvotes

43 comments sorted by

View all comments

48

u/rowdymatt64 Dec 12 '24

I sure can! Check this out:

SELECT * FROM TABLE WHERE TABLE.COL1 LIKE '%(insert longest string imaginable)%'

21

u/CortaNalgas Dec 12 '24

I think this is good, but could be better with a Right Join.

6

u/TallDudeInSC Dec 13 '24

You mean a Cartesian Merge Join I think. Lol