Hello, I’m quite used to SQL, but new to MongoDB.
Before asking I searched a lot on the Internet and in this forum, but didn’t come up with even some method to translate the following kind of SQL update into MongoDB:
UPDATE Authors SET lastName=REPLACE(lastName, ‘DE’, ‘OF’) WHERE city LIKE ‘%new%’
Is there any way to perform such an update through the simple shell? Maye I overlooked some relevant topic, being a newbie, even addressing to a relevant post could help!
Thank you very much in advance!