Title: SQL: Export Comments by Author?
Last modified: August 19, 2016

---

# SQL: Export Comments by Author?

 *  [fireundubh](https://wordpress.org/support/users/fireundubh/)
 * (@fireundubh)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/)
 * What is the SQL code for exporting all comments from database by author’s name
   or e-mail address? Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)

 *  Thread Starter [fireundubh](https://wordpress.org/support/users/fireundubh/)
 * (@fireundubh)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/#post-874968)
 * Bump.
 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/#post-874969)
 * search got you down?
 * honestly, why not fire up phpmyadmin and do a little tinkering?????
 * >  SELECT * FROM my_comments where comment_author_email = ‘name@email.com’;
 * the above is from the cli so ive removed the backticks that are usually needed
   in phpmyadmin — the forum mangles them here anyway.
 * look at the name of the various fields inside your comments table for what to
   use in the case of the the comment author’s name.
 *  [whooami](https://wordpress.org/support/users/whooami/)
 * (@whooami)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/#post-874970)
 * oh, i shouold add too, that if youre using phpmyadmin, after running thyat query,
   you would just click the export button.
 *  Thread Starter [fireundubh](https://wordpress.org/support/users/fireundubh/)
 * (@fireundubh)
 * [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/#post-874980)
 * Thanks. I’ll try this out.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘SQL: Export Comments by Author?’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 4 replies
 * 2 participants
 * Last reply from: [fireundubh](https://wordpress.org/support/users/fireundubh/)
 * Last activity: [17 years, 8 months ago](https://wordpress.org/support/topic/sql-export-posts-by-author/#post-874980)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics