It was easy using phpMyAdmin to pull a list of WordPress admin comments that were missing an IP location, but now that I’ve got that data in hand I’m looking for a quick way to insert it into the table. My guess is that’ll probably be the use (upload) of a .sql file.
I’ve currently got my fresh data in an Excel sheet, with columns for comment_ID and comment_author_IP. There are several hundred records, with a variety of IP addresses.
UPDATE:
The winning query:
UPDATE wp_comments x, temp xx
SET x.comment_author_IP = xx.IP
WHERE x.comment_ID = xx.ID;
If you are looking into a manual and easy process