sql - MySQL UPDATE and SELECT from same table in subquery - Stack Overflow

I'm not sure if this is quite what you're trying to do, but maybe I can show you something to put you on the right path. UPDATE some_table ST SET some_col = ( SELECT some_col FROM some_table OT WHERE OT.ID = ST.ID ) WHERE ST.some_col > 2

stackoverflow.com