title: Update mysql table with data from another table
body: <p>Is it possible to run an UPDATE command on mysql 5.0 with a sub select.</p>
  
  <p>The command I would like to run is this:</p>
  
  <pre><code>UPDATE book_details
  SET live = 1 
  WHERE ISBN13 = '(SELECT ISBN13 FROM book_details_old WHERE live = 1)';
  </code></pre>
  
  <p>ISBN13 is currently stored as a string.</p>
  
  <p>This should be updating 10k+ rows.</p>
  
  <p>Thanks,</p>
  
  <p>William</p>