Title: SQL code for replacing Comment Author info
Last modified: August 20, 2016

---

# SQL code for replacing Comment Author info

 *  [naveenkumar](https://wordpress.org/support/users/naveenkumar/)
 * (@naveenkumar)
 * [13 years, 7 months ago](https://wordpress.org/support/topic/sql-code-for-replacing-comment-author-info/)
 * Hi:
 * I just imported a multiblog of Drupal into WordPress. Now, all comments are showing
   up with just the author names. No clickable URL back to the author blog.
 * I want to replace those details manually through SQL commands. No of authors 
   are less (less than 100), but the comments are in thousands.
 * Could any one please tell me the SQL command to replace the “E-mail” and “URL”
   fields of a particular author in all “comments” made by him/her.
 * Thanks in advance!

The topic ‘SQL code for replacing Comment Author info’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 0 replies
 * 1 participant
 * Last reply from: [naveenkumar](https://wordpress.org/support/users/naveenkumar/)
 * Last activity: [13 years, 7 months ago](https://wordpress.org/support/topic/sql-code-for-replacing-comment-author-info/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics