WP SQL – Remove comment agent18 Juil 2013, Posted by in
By default, when someone comments on your blog, WordPress saves the user agent in the database. It can be useful for stats, but for 95% of bloggers it is just useless. This query will replace the user agent with a blank string, which can reduce your database size if you have lots of comments.
update wp_comments set comment_agent ='' ;