this post was submitted on 26 Oct 2023
285 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
285
submitted 11 months ago* (last edited 11 months ago) by DeadNinja to c/sql
 

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
[–] asterfield 29 points 11 months 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