Great moments in coding amusement

 So I've been spending a lot of time re-working this database backed website, and I'm moving towards it going 'live' so I've got a copy of the database and I'm running the modifcations.  One of the queries I had goes something like this:

mysql> -- This will likely take something like 5 minutes?

mysql> update table1,table2 set table1.guilty_id = table2.id where table1.guilty = table2.name;

Query OK, 3128414 rows affected (1 day 9 hours 14 min 53.02 sec)

Rows matched: 3128414  Changed: 3128414  Warnings: 0

Something tells me the first time I ran that query, and it took only 5 minutes, was a fluke!