Turns out you might be able to do a nested SELECT to get around that second issue, see http://www.xaprb.com/blog/2006/06/23/how-to-select-from-an-update-target-in-mysql/
Turns out you might be able to do a nested SELECT to get around that second issue, see http:// www.xaprb. com/blog/ 2006/06/ 23/how- to-select- from-an- update- target- in-mysql/