Execute SQL Query 
This section allows you to run arbitrary queries on your database. This is often helpful for making many changes quickly or troubleshooting. It is accessible via Maintenance > Execute SQL Query.
The ability to execute an arbitrary query is a powerful one. It can ease administration at times, but it has the potential of destroying your database. Be sure the query you are running is exactly what you want.
Upon entering this section, you will see a page like this:

Your user ID must be in the $config['SpecialUsers']['canrunqueries'] variable in config.php to access this page. See Editing the vBulletin Configuration File.
If your query returns a result set, you will see a page similar to this after running it:

At the top, you will see the query you ran. At the bottom, you will see the results of your query. Each column in the table is a column of data being returned by the query. Thus, in this example, avatarid, title, minimumposts, avatarpath, imagecategoryid, and displayorder are columns in the vb3_avatar table.
User Contributed Notes: Execute SQL Query Add a Comment