Check WordPress Version in a mysql database

Issue

I’m a wordpress designer & developer and I want to know if if it’s possible to check my wordpress version in tables of mysql database to print it in an administration panel page ?

Solution

Should be in wp_options table, the field is called db_version. So, yes, it’s possible.

You can run this SQL command (substitute your table name if different):

SELECT * FROM `wp_options` where option_name = 'db_version'

Make sure to consult the codex, as the db_version looks different from the wp version. for instance:

For Version 3.1, the database version (db_version in wp_options)
changed to 17056, and the Trac revision was 17485.

See https://codex.wordpress.org/WordPress_Versions for a cross reference of db_version (database version) to Word Press release.

Alternatively, you can find the file in the wordpress installation, inside the folder “wp-incudes”. The file is called version.php and defines a global variable like so:

/**
 * The WordPress version string
 *
 * @global string $wp_version
 */
$wp_version = '3.7.1';

Answered By – Halaster

This Answer collected from stackoverflow, is licensed under cc by-sa 2.5 , cc by-sa 3.0 and cc by-sa 4.0

Leave a Reply

(*) Required, Your email will not be published