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
286
submitted 1 year ago* (last edited 1 year ago) by [email protected] to c/[email protected]
 

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] 29 points 1 year ago

I’m no mongo fan, but this is ragebait.

You can write it like this, but you can also write {age: {$gte: 25, $lt: 30}}

If you’re going to dunk on mongo, let’s talk about how db.collection.update() replaces the whole record by default instead of updating keys