Copy blob from one row to another
Poor man's change:

mysql&gt; CREATE TABLE `foo` (
  `id` tinyint(4) NOT NULL AUTO_INCREMENT,
  `content` blob,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8

mysql&gt; INSERT INTO foo VALUES (NULL, 'bar'), (NULL, 'another_bar');

mysql&gt; SELECT * FROM foo;
+----+-------------+
| id | content     |
+----+-------------+
|  1 | bar         |
|  2 | another_bar |
+----+-------------+
2 rows in set

mysql&gt; SELECT content INTO @newContent FROM foo WHERE id=2;

mysql&gt; UPDATE foo SET content=@newContent WHERE id=1;

mysql&gt; SELECT * FROM foo;
+----+-------------+
| id | content     |
+----+-------------+
|  1 | another_bar |
|  2 | another_bar |
+----+-------------+
2 rows in set


And now I've done it without using session variables:

 UPDATE foo, (SELECT content AS selectContent FROM foo WHERE id=2)selectFoo 
  SET content=selectContent 
  WHERE id=1;