title: Loop through column and update it with MySQL?
body: <p>I want to loop through some records and update them with an ad hoc query in MySql. I have a name field, so I just want to loop though all of them and append a counter to each name, so it will be name1, name2, name3.  Most examples I see use stored procs, but I don't need a stored proc.</p>