ParentFull threadnicoburns·Previously you would have to SELECT and then UPDATE in separate queries, meaning that the data is round tripping to your application server and back again.Edit: Or use subqueries apparently.View on HN