Fabricio Carella

This plugin will allow you to execute any type of SQL query into the WordPress’s DB connecting through the driver provided by the MySQLi extension without the need to use another tool like phpMyAdmin.
It also gives you the ability to export the results in a CSV format file.
In order to access this plugin’s admin page (Tools -> Run SQL Query), your account needs to have the <code>install_plugins</code> capability, that means a Super Admin in the multi-site installation or an Admin in a single site.
Feel free to contribute: 
https://github.com/Sefirost/run-sql-query
Use on you own risk. Under no circumstances will the Author of this plugin assume responsibility or liability for any damages or destructive effects on the database resulting from the queries executed using this tool.

Run SQL Query

Run SQL Query is a simple plugin to quickly execute any type of SQL query into the WordPress's DB and export the results in a CSV format file.

Frank Bueltge

Inpsyde GmbH

Simon Kraft

WP Media

ChriCo

Rene Reimann

s-hinse

With Search & Replace you can search for everything and replace this with everything but before you do this you can easily create a simple database backup and restore it.
For avoiding problem please keep in mind that this plugin search and replace strictly what is specified in “Replace With”. 
Common error example: 
Search For: http://web.com/wordpress/ 
Replace With: http://neuweb.com/wordpress 
The url become something like: http://neuweb.com/wordpresscontent/…
Correct “Replace with”: 
Search For: http://web.com/wordpress/ 
Replace With: http://neuweb.com/wordpress/ 
The url become something like: http://neuweb.com/wordpress/content/…
We have implemented special features!
The first one is “Replace a Domain / URL” that is useful for a quick and simple transfer or a migration of a WordPress site. 
The second feature is full support for serialized data. There are a lot more features – check them out! 🙂
Our goal with this plugin is to give you a good solution for manipulating your data for both Developers and Users of WordPress.
<blockquote>
Note: This plugin requires PHP 5.6 or higher to be activated.
</blockquote>
<a href="https://github.com/wp-media/search-and-replace" rel="nofollow ugc">Checkout our GitHub Repository</a>
<h4>Features</h4>
<ul>
<li>Search & replace data in your WordPress database</li>
<li>Change domain/URL of WordPress installation</li>
<li>Handle serialized data</li>
<li>Choose dry run or download SQL file</li>
<li>Change table prefix</li>
<li>Backup & restore your database</li>
<li>WordPress Multisite support</li>
<li>Localized and ready for your own language</li>
</ul>
<h4>Crafted by WP Media</h4>
Made by <a href="https://wp-media.me" rel="nofollow ugc">WP Media</a>.
<h4>Donation?</h4>
You want to donate – we prefer a <a href="https://wordpress.org/support/view/plugin-reviews/search-and-replace?rate=5#postform" rel="ugc">positive review</a>, not more.

Search & Replace

Search & Replace data in your database with WordPress admin, replace domains/URLs of your WordPress installation.

Run SQL Query vs Search & Replace