Database

[{"userId":"100","guilds":[{"guildId":"1","level":1,"xp":1}]}]

Query

db.collection.update({"userId":"100","guilds.guildId":"1"},{"$set":{"guilds.$.xp":5}})

Result

MongoDB version 8.0.16 - Report an issue - About this playground