Update mysql table with data from another table - Stack Overflow

Is it possible to run an UPDATE command on mysql 5.0 with a sub select. The command I would like to run is this: UPDATE book_details SET live = 1 WHERE ISBN13 = '(SELECT ISBN13 FROM book_details... ... To update a table from data in other table

stackoverflow.com