WordPress 5 Cookbook

Viewing data of selected records

The How it works sections of many recipes use certain values in the database for the explanations. In such recipes, you have to retrieve certain database records using SQL queries. You can use the following steps to execute a query and view the necessary data for the recipes:

1. Select one of the tables in your database.
2. Click on the SQL tab to get a screen similar to the following:

3. To select a record from the wp_options table, replace the default query with the following query. You should replace NAME of THE OPTION with the option name you want to check:

SELECT * FROM `wp_options` WHERE `option_name`='NAME ...