sql - How to select same table in update statement with MySQL ...

2011年11月3日 - EDIT - after UPDATE with sample data from OP: I assume you know the ID (=11) and want the data to change as illustrated in your updated question...

stackoverflow.com