In the following simple solution, I’ll show you how to Search and Replace SQL database information from PhpMyAdmin. This SQL query method is extremely helpful when you need to replace multiple text strings and do not wish to export the entire database just to make those changes. With the SQL Search and Replace (SQL Query Method) the database changes can be made instantly on the fly.
With WordPress, you can globally disable comments, if you do not want to allow comments to be placed on your blog. Since this information is stored in the database, we can edit the allow comments option (open or close comments) across the entire blog in one step. This tutorial explains how to remove all instances of Allow Comments by using an SQL database query.