join - MySQL update table based on another tables value - Stack ...

In addition to Tom's answer if you need to repeat the operation frequently and want to save time you can do: UPDATE TABLE1 JOIN TABLE2 ON ...

www.google.com.tw