this post was submitted on 26 Oct 2023
286 points (96.4% liked)

SQL - any and all

305 readers
1 users here now

For discussion about SQL and databases. All versions welcome.

founded 1 year ago
MODERATORS
[email protected]
286
SQL Dev learning MongoDB (lemmy.world)
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
50 comments fedilink hide all child comments
 

Jesus died at 33, so that can't get returned in the query response lol

you are viewing a single comment's thread
view the rest of the comments
[โ€“] [email protected] 12 points 1 year ago* (last edited 1 year ago) (1 children)

It's a mess compared to the equivalent SQL.

SELECT *
FROM users
WHERE age >= 25 AND age <= 30

I dislike SQL syntax more than most, and even I concede that SQL wins in this instance.

Edit: Not sure if this appears on all clients but the < in the code block is meant to be a less-than symbol.

[โ€“] [email protected] 4 points 1 year ago

There is no way I would ever get the amount of brackets right on that.