{"id":1392,"date":"2021-07-26T06:32:22","date_gmt":"2021-07-26T11:32:22","guid":{"rendered":"https:\/\/www.knownhost.com\/kb\/?p=1392"},"modified":"2021-11-22T06:51:23","modified_gmt":"2021-11-22T12:51:23","slug":"wordpress-frequently-asked-questions","status":"publish","type":"post","link":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/","title":{"rendered":"WordPress Frequently Asked Questions"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-right counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #212121;color:#212121\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #212121;color:#212121\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 eztoc-toggle-hide-by-default' ><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#whats_the_1_rule_about_working_with_the_wordpress_database_tables\" >What&#8217;s the #1 Rule About Working with the WordPress Database \/ Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#whats_the_2_rule_about_working_with_the_wordpress_database_tables\" >What&#8217;s the #2 Rule About Working with the WordPress Database \/ Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_phpmyadmin\" >What is PHPMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_connect_to_the_wordpress_database\" >How to Connect to the WordPress Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#whats_my_wordpress_database_user_and_password\" >What&#8217;s my WordPress database user and password?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#whats_my_database_prefix\" >What&#8217;s My Database Prefix?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#is_it_okay_if_my_database_prefix_isnt_wp\" >Is it Okay if My Database Prefix Isn&#8217;t wp_?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_create_a_working_wp-configphp\" >How to Create a Working wp-config.php?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_languages_are_used_by_wordpress\" >What Languages are Used by WordPress?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_backup_entire_wordpress_database_using_phpmyadmin\" >How to Backup Entire WordPress Database Using PHPMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_backup_or_export_wordpress_comments_using_phpmyadmin\" >How to Backup or Export WordPress Comments Using PHPMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_export_wordpress_comments_as_csv_or_xml_using_a_plugin\" >How to Export WordPress Comments as CSV (or XML) Using a Plugin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_the_wordpress_table_wp_commentmeta\" >What is the WordPress Table wp_commentmeta?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_all_wordpress_comments_with_phpmyadmin\" >How to Delete All WordPress Comments with phpMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_spam_or_trash_wordpress_comments_with_phpmyadmin\" >How to Delete Spam or Trash WordPress Comments with phpMyAdmin?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_trash_or_delete_all_comments_from_one_post\" >How to Trash or Delete All Comments from One Post?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-17\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_all_unapproved_comments_in_wordpress\" >How to Delete All Unapproved Comments In WordPress?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-18\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_a_sql_select_statement\" >What is a SQL Select Statement?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-19\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_select_some_of_the_information_from_a_table\" >How to Select Some of the Information from a Table?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-20\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_select_all_the_information_from_multiple_tables\" >How to Select All the Information from Multiple Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-21\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_select_related_information_from_two_tables\" >How to Select Related Information From Two Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-22\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_a_sql_update_statement\" >What is a SQL Update Statement?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-23\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_a_sql_delete_statement\" >What is a SQL Delete Statement?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-24\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_import_a_wordpress_database\" >How to Import a WordPress Database?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-25\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_are_the_wordpress_database_tables_associated_with_posts\" >What are the WordPress Database Tables Associated with Posts?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-26\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_are_the_wordpress_database_tables_associated_with_comments\" >What are the WordPress Database Tables Associated with Comments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-27\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_are_the_wordpress_database_tables_associated_with_users\" >What are the WordPress Database Tables Associated with Users?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-28\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_are_the_wordpress_database_tables_associated_with_terms\" >What are the WordPress Database Tables Associated with Terms?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-29\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_the_wordpress_table_associated_with_admin_options\" >What is the WordPress Table Associated with Admin Options?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-30\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_is_the_wordpress_database_table_associated_with_links\" >What is the WordPress Database Table Associated with Links?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-31\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_comments_by_a_certain_user\" >How to Find Comments by a Certain User?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-32\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_comments_and_metadata_from_a_certain_user\" >How to Delete Comments and Metadata from a Certain User?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-33\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_comments_on_a_particular_post_id\" >How to Find Comments on a Particular Post ID?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-34\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_comments_on_a_particular_post_id\" >How to Delete Comments on a Particular Post ID?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-35\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_all_spam_trash_or_unapproved_comments\" >How to Find All Spam, Trash or Unapproved Comments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-36\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_all_spam_trash_or_unapproved_comments_and_associated_metadata\" >How to Delete All Spam, Trash or Unapproved Comments and Associated Metadata?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-37\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_wordpress_metadata_based_on_the_meta_key\" >How to Find WordPress Metadata Based on the meta_key?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-38\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_wordpress_meta_key_based_on_fuzzy_matching_of_the_key\" >How to Find WordPress meta_key Based on Fuzzy Matching of the Key?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-39\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_wordpress_metadata_based_on_the_key\" >How to Delete WordPress Metadata Based on the Key?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-40\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_wordpress_metadata_based_on_the_meta_value\" >How to Find WordPress Metadata Based on the meta_value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-41\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_wordpress_metadata_based_on_the_meta_value\" >How to Delete WordPress Metadata Based on the meta_value?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-42\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_wordpress_administrators\" >How to Find WordPress Administrators?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-43\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_remove_some_wordpress_administrators\" >How to Remove Some WordPress Administrators?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-44\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_remove_wordpress_users_with_no_posts_or_comments\" >How to Remove WordPress Users with No Posts or Comments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-45\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_comments_and_comment_meta_without_joining_tables\" >How to Delete Comments and Comment Meta Without Joining Tables?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-46\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_comments_and_meta_made_within_a_date_range_alternative\" >How to Delete Comments and Meta Made Within a Date Range (alternative)?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-47\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_disable_comments_on_all_posts\" >How to Disable Comments on All Posts?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-48\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_disable_comments_only_on_older_posts\" >How to Disable Comments Only on Older Posts?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-49\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_set_a_new_admin_password\" >How to Set a New Admin Password?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-50\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_delete_all_approved_comments\" >How to Delete All Approved Comments?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-51\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_get_comment_counts_by_author\" >How to Get Comment Counts by Author?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-52\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_comment_spammers_by_activity_of_ip_address\" >How to Find Comment Spammers by Activity of IP Address?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-53\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_extract_contact_details_of_commenters_for_email_marketing_list_building\" >How to Extract Contact Details of Commenters for Email Marketing List Building?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-54\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_reset_wordpress_theme_to_default_when_site_is_crashing_using_sql\" >How to Reset WordPress Theme to Default When Site is Crashing using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-55\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_change_wordpress_pages_to_posts_using_sql\" >How to Change WordPress Pages to Posts using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-56\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#how_to_find_wordpress_category_id_via_category_name_using_sql\" >How to Find WordPress Category ID via Category Name using SQL?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-57\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#when_setting_to_ping_or_pinged_in_wordpress_wp_posts_what_delimiter_should_be_used\" >When Setting to_ping or pinged in WordPress wp_posts, What Delimiter Should be Used?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-58\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_are_valid_post_types_in_wordpress\" >What are Valid Post Types in WordPress?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-59\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#what_4_languages_represent_the_database_commands_for_mysql\" >What 4 Languages Represent the Database Commands for MySQL?<\/a><\/li><\/ul><\/nav><\/div>\n\n<h3 class=\"wp-block-heading\" id=\"what_s_the_1_rule_about_working_with_the_wordpress_databasetables\"><span class=\"ez-toc-section\" id=\"whats_the_1_rule_about_working_with_the_wordpress_database_tables\"><\/span>What&#8217;s the #1 Rule About Working with the WordPress Database \/ Tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The most important WordPress rule is to <a href=\"https:\/\/www.knownhost.com\/kb\/how-to-take-full-backup-using-backup-wizard-in-cpanel\/\">backup the database<\/a> before making changes!<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_s_the_2_rule_about_working_with_the_wordpress_databasetables\"><span class=\"ez-toc-section\" id=\"whats_the_2_rule_about_working_with_the_wordpress_database_tables\"><\/span>What&#8217;s the #2 Rule About Working with the WordPress Database \/ Tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make sure you work on the table you&#8217;re concerned with as well as the meta tables that contain important linked information.<\/p>\n\n\n\n<p>Examples of linked tables include:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  wp_comments -&gt; wp_commentmeta\n  wp_users -&gt; wp_usermeta\n  wp_psots -&gt; wp_postmeta<\/code><\/pre>\n\n\n\n<p>You should remove entries in both the table and metadata table that relates to it, whenever removing records in the table.<\/p>\n\n\n\n<p>For example, rather than just removing rows in wp_comments, to avoid leaving orphaned rows that make the database larger and slower than necessary, you would remove rows in wp_commentmeta as well as wp_comments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_phpmyadmin\"><span class=\"ez-toc-section\" id=\"what_is_phpmyadmin\"><\/span>What is PHPMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It\u2019s free software that enables you to administer SQL databases over the web. Databases are typically MySQL or MariaDB. Functions include everything from changing permissions to modifying\/adding\/removing databases, tables, rows within tables, relationships between tables, and other common admin functions.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_connect_to_the_wordpress_database\"><span class=\"ez-toc-section\" id=\"how_to_connect_to_the_wordpress_database\"><\/span>How to Connect to the WordPress Database?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Look in the file wp-config.php. That file has all the connection information.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_s_my_wordpress_database_user_and_password\"><span class=\"ez-toc-section\" id=\"whats_my_wordpress_database_user_and_password\"><\/span>What&#8217;s my WordPress database user and password?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>See the section on wp-config.php. That file, in the main folder of your WordPress install, contains database name and database server, username and password.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_s_my_database_prefix\"><span class=\"ez-toc-section\" id=\"whats_my_database_prefix\"><\/span>What&#8217;s My Database Prefix?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The default prefix is wp_ and is set via wp-config.php in the $table_prefix line.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  $table_prefix = 'wp_';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"is_it_okay_if_my_database_prefix_isn_t_wp\"><span class=\"ez-toc-section\" id=\"is_it_okay_if_my_database_prefix_isnt_wp\"><\/span>Is it Okay if My Database Prefix Isn&#8217;t wp_?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Yes, you can set a different, more secure, default database prefix in wp-config.php.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_create_a_working_wp-configphp\"><span class=\"ez-toc-section\" id=\"how_to_create_a_working_wp-configphp\"><\/span>How to Create a Working wp-config.php?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Rather than hand editing your config file, the good folks at GenerateWP have created a tool to do the heavy lifting. Click on each tabbed section, fill in the blanks, click update code and you&#8217;ll get a complete wp-config.php tailored to your specifications.<\/p>\n\n\n\n<p><a href=\"https:\/\/generatewp.com\/wp-config\/\">wp-config.php Generator<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_languages_are_used_by_wordpress\"><span class=\"ez-toc-section\" id=\"what_languages_are_used_by_wordpress\"><\/span>What Languages are Used by WordPress?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>WordPress files rely on PHP to execute, along with JavaScript and&nbsp;CSS&nbsp;for scripting actions and styling the presentation in web browsers. SQL is used to communicate with the database.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_backup_entire_wordpress_database_using_phpmyadmin\"><span class=\"ez-toc-section\" id=\"how_to_backup_entire_wordpress_database_using_phpmyadmin\"><\/span>How to Backup Entire WordPress Database Using PHPMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Please remember that backing up your database doesn&#8217;t include file backups such as WordPress, themes, plugins, images and other media. You&#8217;ll need a full backup, not just a database backup, in order to preserve all these things.<\/p>\n\n\n\n<p>To backup your database:<\/p>\n\n\n\n<p>Login to your web hosting control panel (cPanel or whatever panel you use).<\/p>\n\n\n\n<p>\u00bb Open PHPMyAdmin \u00bb Select the WordPress database \u00bb Click: Export \u00bb Choose SQL format \u00bb Click: Go<\/p>\n\n\n\n<p>The download prompt should appear in your web browser before saving to your local machine.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_backup_or_export_wordpress_comments_using_phpmyadmin\"><span class=\"ez-toc-section\" id=\"how_to_backup_or_export_wordpress_comments_using_phpmyadmin\"><\/span>How to Backup or Export WordPress Comments Using PHPMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>While we\u2019d recommend backing up the entire site, there can be occasions when you\u2019d just like to get all the comments out of the database, making them portable, perhaps as CSV or tab delimited text.<\/p>\n\n\n\n<p>FYI, all comments in WordPress are stored in the wp_comments table of the WordPress database.<\/p>\n\n\n\n<p>Here\u2019s the quick guide to exporting WordPress comments using PHPMyAdmin:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Login to your web hosting control panel (cPanel or whatever panel you use).<\/li><li>Open PHPMyAdmin<\/li><li>Scroll through the list of tables, then select wp_comments and wp_commentmeta<\/li><li>Click: Export<\/li><li>Choose whatever output format you\u2019d prefer<\/li><li>Click: Save as file<\/li><li>Click: Go<\/li><\/ul>\n\n\n\n<p>The download prompt should appear in your web browser before saving to your local machine in the format specified.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_export_wordpress_comments_as_csv_or_xml_using_a_plugin\"><span class=\"ez-toc-section\" id=\"how_to_export_wordpress_comments_as_csv_or_xml_using_a_plugin\"><\/span>How to Export WordPress Comments as CSV (or XML) Using a Plugin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>WordPress comments can be exported via phpMyAdmin by simply selecting the comments table and exporting into the format of your choice. However, there can be times when you either don\u2019t have access to control panel tools, such as phpMyAdmin, or when you\u2019d like to have this capability via the WordPress admin area, such as when tasks have been delegated to other people and cPanel access isn\u2019t going to be acceptable.<\/p>\n\n\n\n<p>In this case, a plugin may be the answer you\u2019re seeking.<\/p>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;This, and other similar plugins will be able to perform comment updates only after upgrading to premium features (paid software). Sometimes this is necessary if you want to get the functionality for which you\u2019re seeking.<\/p>\n\n\n\n<p>If you\u2019d like to export comments for free, refer to our guidance on how to export using phpMyAdmin &#8211; it won\u2019t cost you anything!<\/p>\n\n\n\n<p>Continue the steps below, keeping in mind you will need the pro version of this plugin [we don\u2019t receive compensation for recommending such]\u2026<\/p>\n\n\n\n<p>Install the WP All Export plugin using our How to Install Plugins procedure:&nbsp;<a href=\"https:\/\/wordpress.org\/plugins\/wp-all-export\/\">Export any WordPress data to XML\/CSV<\/a><\/p>\n\n\n\n<p>Once you\u2019ve installed and activated the plugin, navigate to:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  WP Admin -&gt; All Export<\/code><\/pre>\n\n\n\n<p>Then click on the Specific Post Type button and in the dropdown select Comments.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_the_wordpress_table_wp_commentmeta\"><span class=\"ez-toc-section\" id=\"what_is_the_wordpress_table_wp_commentmeta\"><\/span>What is the WordPress Table wp_commentmeta?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Having the foresight to know software developers might want to extend WordPress comments in hundreds of different directions, the WordPress database has had an additional table added that goes along with wp_comments table.<\/p>\n\n\n\n<p>In the interest of performance and extensibility, WordPress comments functionality can expand, without needing to add columns to the wp_comments table for each and every addition. Keeping the core wp_comments as is, then adding meta information via the wp_commentmeta table is a tactic similar to other sections of the database.<\/p>\n\n\n\n<p>If you\u2019re wondering what might go into wp_commentmeta\u2026. Perhaps you\u2019d like to install a plugin that allows voting on each comment, a bit like Reddit or Stack Overflow. Keeping the voting details in wp_commentmeta keeps wp_comments lean and meta information all in one separate table.<\/p>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;If you\u2019ve used custom table name prefixes, your WordPress database tables might not start with wp_. In that case, you\u2019d still be looking for commentmeta, just with a different prefix at the beginning.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_all_wordpress_comments_with_phpmyadmin\"><span class=\"ez-toc-section\" id=\"how_to_delete_all_wordpress_comments_with_phpmyadmin\"><\/span>How to Delete All WordPress Comments with phpMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before making major changes such as removing all your blog comments, make a database backup!<\/p>\n\n\n\n<p>Deleting all comments via phpMyAdmin is a quick way of getting rid of a massive spam accumulation, particularly when you haven\u2019t got any quality comments to worry about retaining.<\/p>\n\n\n\n<p>WordPress comments are stored in the database table wp_comments (replacing wp_ with whatever alternative prefix you may have used at installation time, if you used an alternative prefix). Typically, a large amount of metadata is stored in another table wp_commentmeta. This means that clearing comments will require cleaning up both wp_comments and wp_commentmeta tables.<\/p>\n\n\n\n<p>Deleting all can be accomplished by opening your WordPress database in phpMyAdmin, selecting the tick boxes next to wp_comments and wp_commentmeta, then selecting the dropdown under the table list \u201cWith selected\u201d and choosing Empty from the list of choices.<\/p>\n\n\n\n<p>You\u2019ll be prompted to TRUNCATE both tables, with phpMyAdmin making sure you really, really want to do that. Pick yes, and your comments will disappear.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_spam_or_trash_wordpress_comments_with_phpmyadmin\"><span class=\"ez-toc-section\" id=\"how_to_delete_spam_or_trash_wordpress_comments_with_phpmyadmin\"><\/span>How to Delete Spam or Trash WordPress Comments with phpMyAdmin?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Before making major changes such as removing all your blog comments, make a database backup!<\/p>\n\n\n\n<p>WordPress comments are stored in the database table wp_comments (replacing wp_ with whatever alternative prefix you may have used at installation time, if you used an alternative prefix). Typically, a large amount of metadata is stored in another table wp_commentmeta. This means that clearing comments will require cleaning up both wp_comments and wp_commentmeta tables.<\/p>\n\n\n\n<p>Comments with a status of \u201cspam\u201d can be identified in the wp_comments table with a value of \u201ccomment_approved = \u2018spam\u2019\u201d. Trash comments will be \u201ccomment_approved = \u2018trash\u2019\u201d.<\/p>\n\n\n\n<p>Deleting either can be accomplished by opening your WordPress database in phpMyAdmin and clicking the SQL tab.<\/p>\n\n\n\n<p><em>Spam<\/em><\/p>\n\n\n\n<p>You can delete all comments flagged as spam by pasting this into the SQL text box and then clicking go:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE from wp_comments WHERE comment_approved = 'spam';<\/code><\/pre>\n\n\n\n<p><em>Trash<\/em><\/p>\n\n\n\n<p>To delete all comments flagged as trash, paste this into the SQL text box and then click go:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE from wp_comments WHERE comment_approved = 'trash';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_trash_or_delete_all_comments_from_one_post\"><span class=\"ez-toc-section\" id=\"how_to_trash_or_delete_all_comments_from_one_post\"><\/span>How to Trash or Delete All Comments from One Post?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make a backup of your database before executing queries directly.<\/p>\n\n\n\n<p>If you\u2019d like to flag all the comments on a particular post as being trash, you\u2019ll need the post ID. You can either browse the WordPress database, which could take some time if you\u2019ve got a number of posts, or you can find it via WP admin.<\/p>\n\n\n\n<p>To find the post ID, click on Posts then find the post you want to work on and click Edit.<\/p>\n\n\n\n<p>Now, look at the&nbsp;URL&nbsp;bar. It will have a number of bits of information that are&nbsp;URL&nbsp;encoded, but you should easily be able to spot the \u201cpost=XXX\u201d where XXX is the post ID.<\/p>\n\n\n\n<p>If the post ID was 123, you\u2019d be able to use phpMyAdmin SQL tool to execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_comments SET comment_approved='trash' WHERE comment_post_ID=123;<\/code><\/pre>\n\n\n\n<p>The result would be all comments associated with that post would be marked as trash.<\/p>\n\n\n\n<p>If you\u2019d instead like to delete all the comments associated with the post, you could delete comments from post 123 with:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE from wp_comments WHERE comment_post_ID=123;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_all_unapproved_comments_in_wordpress\"><span class=\"ez-toc-section\" id=\"how_to_delete_all_unapproved_comments_in_wordpress\"><\/span>How to Delete All Unapproved Comments In WordPress?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make a backup of your database before executing queries directly. Executing this SQL statement will result in your entire queue of unapproved comments awaiting moderation to be blanked entirely.<\/p>\n\n\n\n<p>Comments that haven\u2019t been approved are stored in the wp_comments table of your database with a comment_approved status, or value, of \u201c0\u201d.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = \"0\";<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_a_sql_select_statement\"><span class=\"ez-toc-section\" id=\"what_is_a_sql_select_statement\"><\/span>What is a SQL Select Statement?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When you\u2019re looking to get data from a database table, a SQL select statement is how you ask the database (query it) for information. The result of that query is a result-set.<\/p>\n\n\n\n<p>The statement should be<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>SELECT ____from____;<\/code><\/pre>\n\n\n\n<p>In these you are asking for certain information from a particular table in the database.<\/p>\n\n\n\n<p>When you SELECT *, you are asking for everything to be outputted from a particular table or tables.<\/p>\n\n\n\n<p><em>Examples<\/em>:<\/p>\n\n\n\n<p>Show all the comments in the WordPress database:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_comments;<\/code><\/pre>\n\n\n\n<p>Show all the users who are registered in the system:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_users;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_select_some_of_the_information_from_a_table\"><\/span>How to Select Some of the Information from a Table?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT comment_author, comment_author_email, comment_content FROM wp_comments;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_select_all_the_information_from_multiple_tables\"><\/span>How to Select All the Information from Multiple Tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_comments, wp_commentmeta;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_select_related_information_from_two_tables\"><\/span>How to Select Related Information From Two Tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT wp_comments.comment_ID, wp_comments.comment_author,\n  wp_comments.comment_content , wp_commentmeta.meta_key,\n  wp_commentmeta.meta_value\n  FROM wp_comments\n  INNER JOIN wp_commentmeta ON\n  wp_comments.comment_ID=wp_commentmeta.comment_id;<\/code><\/pre>\n\n\n\n<p>In the above example, the select statement is designed to pull all the authors and their comments, with linked metadata.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_a_sql_update_statement\"><span class=\"ez-toc-section\" id=\"what_is_a_sql_update_statement\"><\/span>What is a SQL Update Statement?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When you\u2019re looking to modify data in one or more database tables, a SQL update statement is how you tell the database to change information.<\/p>\n\n\n\n<p>The statement should be<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE ___ SET ____=_____;<\/code><\/pre>\n\n\n\n<p><em>Examples:<\/em><\/p>\n\n\n\n<p>Update all comments in the WordPress database so that their status is set to trash Execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_comments SET comment_approved='trash';<\/code><\/pre>\n\n\n\n<p>Update comments in the WordPress database so that their status is set to trash, based on a particular post ID. If the post ID was 123, you\u2019d be able to use phpMyAdmin SQL tool to execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_comments SET comment_approved='trash' WHERE comment_post_ID=123;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_a_sql_delete_statement\"><span class=\"ez-toc-section\" id=\"what_is_a_sql_delete_statement\"><\/span>What is a SQL Delete Statement?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When you\u2019re looking to delete data in one or more database tables, a SQL delete statement is how you tell the database to remove information.<\/p>\n\n\n\n<p>The statement should be<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM ___ WHERE ____;<\/code><\/pre>\n\n\n\n<p>Examples:<\/p>\n\n\n\n<p>Delete all approved comments<\/p>\n\n\n\n<p>Execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = '1';<\/code><\/pre>\n\n\n\n<p>Delete comments and associated commentmeta at the same time<\/p>\n\n\n\n<p>Execute:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_comments, wp_commentmeta FROM wp_comments INNER JOIN\n  wp_commentmeta WHERE wp_comments.comment_id=wp_commentmeta.comment_ID AND\n  wp_comments.user_id = 0;\n  DELETE FROM wp_comments WHERE user_id = 0;<\/code><\/pre>\n\n\n\n<p>The above will remove comments and metadata from unregistered users (user_id=0).<\/p>\n\n\n\n<p>Delete commentmeta, then comments for any comment which has text \u201cABC\u201d within the comment content<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_content LIKE '%ABC%');<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_content LIKE '%ABC%';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_import_a_wordpress_database\"><span class=\"ez-toc-section\" id=\"how_to_import_a_wordpress_database\"><\/span>How to Import a WordPress Database?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Assuming you\u2019ve got a blank database created in PHPMyAdmin named \u201cmywpdb\u201d\u2026.<\/p>\n\n\n\n<p>Select the database from within PHPMyAdmin.<\/p>\n\n\n\n<p>Click Import at the top.<\/p>\n\n\n\n<p>Choose UTF-8, or whatever character set was used in creating the backup file you\u2019re about to import.<\/p>\n\n\n\n<p>Click on the Browse Your Computer \u201cChoose File\u201d button, find the file and pick okay.<\/p>\n\n\n\n<p>Once it completes, you\u2019ll see a message that Import has been successfully finished.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_are_the_wordpress_database_tables_associated_with_posts\"><span class=\"ez-toc-section\" id=\"what_are_the_wordpress_database_tables_associated_with_posts\"><\/span>What are the WordPress Database Tables Associated with Posts?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_posts<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  ID: post unique reference number\n  comment_count: comment + pingback + trackback count\n  comment_status: whether or not comments are allowed\n  guid: Global Unique Identifier - full URL, not permalink, of the post\n  menu_order: used for menu display number\n  pinged: list of URLs that got pingback notifications to when updated.\n  ping_status: whether or not pingbacks and trackbacks are allowed to post\n  post_author: ID of the wp_user ID who created the post\n  post_content: post content\n  post_content_filtered: cached version for plugin usepost_date: post creation date and time\n  post_date_gmt: post creation date and time in GMT\n  post_excerpt: post shortened introduction to the content\n  post_mime_type: attachment MIME type\n  post_modified: when the post was last modified, date and time\n  post_modified_gmt: when the post was last modified in GMT\n  post_name: post title slug (for URLs)\n  post_parent: links to another post when revising or attaching\n  post_password: if password protected, this is the password used for access\n  post_status: post status such as whether it is published, draft or awaiting publishing\n  post_title: post title\n  post_type: what content type is the post\n  to_ping: pingback list of URLs to notify on update or publishing<\/code><\/pre>\n\n\n\n<p>wp_postmeta<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  meta_id: ID for the post metadata\n  post_id: the ID for the wp_posts associated post\n  meta_key: an identifying key for the piece of data.\n  meta_value: the actual piece of data.<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_are_the_wordpress_database_tables_associated_with_comments\"><span class=\"ez-toc-section\" id=\"what_are_the_wordpress_database_tables_associated_with_comments\"><\/span>What are the WordPress Database Tables Associated with Comments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_comments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  comment_ID: ID for the comment\n  comment_post_ID: The post for which the comment is posted\n  comment_author: Comment author name\n  comment_author_email: Author name for the comment\n  comment_author_url: Author url\n  comment_author_IP: Author IP address\n  comment_date: Comment Date\n  comment_date_gmt: GMT time of the comment\n  comment_content: Contents of the comment (comment body)\n  comment_karma: unused\n  comment_approved: Flag for the comment status.\n  comment_agent: browser agent\n  comment_type: comment (null?), pingback or trackback\n  comment_parent: For threaded comment\n  user_id: user id if comment author is a registered user of the site.<\/code><\/pre>\n\n\n\n<p>wp_commentmeta<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  meta_id: ID for the comment metadata\n  comment_id: ID for the comment associated\n  meta_key: What kind of metadata\n  meta_value: The metadata<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_are_the_wordpress_database_tables_associated_with_users\"><span class=\"ez-toc-section\" id=\"what_are_the_wordpress_database_tables_associated_with_users\"><\/span>What are the WordPress Database Tables Associated with Users?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_users<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  ID: unique ID for the user\n  display_name: shown name of user\n  user_activation_key: key to activate user registration on lost password requests\n  user_email: user email address\n  user_login: user login name\n  user_nicename: user alternative display name\n  user_pass: user login password\n  user_registered: date and time the user registered\n  user_status: deprecated user status no longer used\n  user_url: user site URL<\/code><\/pre>\n\n\n\n<p>wp_usermeta<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  umeta_id: ID for the user metadata\n  user_id: ID for the user associated\n  meta_key: What kind of metadata\n  meta_value: The metadata<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_are_the_wordpress_database_tables_associated_with_terms\"><span class=\"ez-toc-section\" id=\"what_are_the_wordpress_database_tables_associated_with_terms\"><\/span>What are the WordPress Database Tables Associated with Terms?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_terms<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  term_id \u2013 ID for the term\n  name \u2013 term name\n  slug \u2013 slug of the name (URL)\n  term_group \u2013 group name for pooling terms together<\/code><\/pre>\n\n\n\n<p>wp_term_taxonomy<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  term_taxonomy_id \u2013 ID for the term taxonomy\n  term_id \u2013 term ID from wp_terms\n  count \u2013 post object count of all assigned this term in the taxonomy\n  description \u2013 taxonomy description of each term\n  parent \u2013 ID of parent terms such as in hierarchical taxonomies such as categories\n  taxonomy \u2013 slug of the taxonomy<\/code><\/pre>\n\n\n\n<p>wp_term_relationships<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  object_id \u2013 ID for the post object in wp_posts\n  term_taxonomy_id \u2013 ID for the term taxonomy pair in wp_term_taxonomy\n  term_order \u2013 ordering of object terms<\/code><\/pre>\n\n\n\n<p>wp_termmeta<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  meta_id \u2013 ID for the term metadata\n  term_id \u2013 term ID from wp_terms\n  meta_key: What kind of metadata\n  meta_value: The metadata<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_the_wordpress_table_associated_with_admin_options\"><span class=\"ez-toc-section\" id=\"what_is_the_wordpress_table_associated_with_admin_options\"><\/span>What is the WordPress Table Associated with Admin Options?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_options<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  option_id \u2013 ID for each option\n  autoload \u2013 whether or not option is automatically loaded\n  option_name \u2013 friendly name of each option\n  option_value \u2013 option data (serialized data most often)<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_is_the_wordpress_database_table_associated_with_links\"><span class=\"ez-toc-section\" id=\"what_is_the_wordpress_database_table_associated_with_links\"><\/span>What is the WordPress Database Table Associated with Links?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>wp_links<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  link_id \u2013 unique ID for each link entry\n  link_description \u2013 link description giving added details\n  link_image \u2013 image URL that relates to the link\n  link_name \u2013 link friendly name\n  link_notes \u2013 link notes\n  link_owner \u2013 user ID of link creator from wp_users table\n  link_rating \u2013 0-10 rating score for the link\n  link_rel \u2013 link relationship\n  link_rss \u2013 link RSS address\n  link_target \u2013 link target such as _blank or _none\n  link_updated \u2013 link update date and time\n  link_url \u2013 link URL\n  link_visible \u2013 whether link is private or public<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_find_comments_by_a_certain_user\"><\/span>How to Find Comments by a Certain User?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_comments WHERE comment_author_email = \u2018email address\u2019;<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;replace \u2018email address\u2019 with the single quote encapsulated actual email address like:&nbsp;<a href=\"mailto:someuser@googlemail.com\">\u2018someuser@googlemail.com\u2019<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_delete_comments_and_metadata_from_a_certain_user\"><\/span>How to Delete Comments and Metadata from a Certain User?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_author_email = 'email address');<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_author_email = 'email address';<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;replace \u2018email address\u2019 with the single quote encapsulated actual email address like:&nbsp;<a href=\"mailto:someuser@googlemail.com\">\u2018someuser@googlemail.com\u2019<\/a><\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_comments_on_a_particular_post_id\"><span class=\"ez-toc-section\" id=\"how_to_find_comments_on_a_particular_post_id\"><\/span>How to Find Comments on a Particular Post ID?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_comments WHERE comment_post_ID = 123;<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;replace 123 with the actual post ID.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_comments_on_a_particular_post_id\"><span class=\"ez-toc-section\" id=\"how_to_delete_comments_on_a_particular_post_id\"><\/span>How to Delete Comments on a Particular Post ID?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_post_ID = 123);<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_post_ID = 123;<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;replace 123 with the actual post ID.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_all_spam_trash_or_unapproved_comments\"><span class=\"ez-toc-section\" id=\"how_to_find_all_spam_trash_or_unapproved_comments\"><\/span>How to Find All Spam, Trash or Unapproved Comments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><em>Spam<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * from wp_comments WHERE comment_approved = 'spam';<\/code><\/pre>\n\n\n\n<p><em>Trash<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * from wp_comments WHERE comment_approved = 'trash';<\/code><\/pre>\n\n\n\n<p><em>Unapproved<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_comments WHERE comment_approved = \"0\";<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_all_spam_trash_or_unapproved_comments_and_associated_metadata\"><span class=\"ez-toc-section\" id=\"how_to_delete_all_spam_trash_or_unapproved_comments_and_associated_metadata\"><\/span>How to Delete All Spam, Trash or Unapproved Comments and Associated Metadata?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p><em>Spam<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_approved = \u2018spam\u2019);<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = \u2018spam\u2019;<\/code><\/pre>\n\n\n\n<p><em>Trash<\/em>:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_approved = \u2018trash\u2019);<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = \u2018trash\u2019;<\/code><\/pre>\n\n\n\n<p><em>Unapproved<\/em><\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE wp_commentmeta WHERE comment_id IN\n    (SELECT comment_ID FROM wp_comments WHERE comment_approved = \u20180\u2019);<\/code><\/pre>\n\n\n\n<p>Then run this:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = \u20180\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_wordpress_metadata_based_on_the_meta_key\"><span class=\"ez-toc-section\" id=\"how_to_find_wordpress_metadata_based_on_the_meta_key\"><\/span>How to Find WordPress Metadata Based on the meta_key?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Users<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_usermeta WHERE meta_key = \u2018job_title\u2019;<\/code><\/pre>\n\n\n\n<p>Posts<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_postmeta WHERE meta_key = \u2018post_rating\u2019;<\/code><\/pre>\n\n\n\n<p>Comments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_commentmeta WHERE meta_key = \u2018comment_vote\u2019;<\/code><\/pre>\n\n\n\n<p>The above queries will find all the metadata associated with particular users, posts or comments, where the meta_key field matches the text list.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_wordpress_meta_key_based_on_fuzzy_matching_of_the_key\"><span class=\"ez-toc-section\" id=\"how_to_find_wordpress_meta_key_based_on_fuzzy_matching_of_the_key\"><\/span>How to Find WordPress meta_key Based on Fuzzy Matching of the Key?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When you don\u2019t know the exact key but have a general idea, you can find a list of meta_key information so that you can then use that in further searches.<\/p>\n\n\n\n<p>Comments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT meta_key FROM wp_commentmeta WHERE meta_key like \u2018%vote%\u2019;<\/code><\/pre>\n\n\n\n<p>By using this approach you\u2019ll see a list of keys with \u2018vote\u2019 in the key. Then, you can drill more data out of the database with further select queries. For example, if you found the key of interest to be \u2018comment_vote\u2019, you could use that in further queries to get all entries in the table where the key matches \u2018comment_vote\u2019.<\/p>\n\n\n\n<p>Comments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_commentmeta WHERE meta_key = \u2018comment_vote\u2019;<\/code><\/pre>\n\n\n\n<p>Or combine the query with pulling in comment text information and metadata at the same time for even more power by joining the two tables and including a where clause.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT wp_comments.comment_ID, wp_comments.comment_content, wp_commentmeta.meta_key, wp_commentmeta.meta_value\n  FROM wp_comments\n    INNER JOIN wp_commentmeta ON\n      wp_comments.comment_ID=wp_commentmeta.comment_id\n    WHERE wp_commentmeta.meta_key=\u2019comment_vote\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_wordpress_metadata_based_on_the_key\"><span class=\"ez-toc-section\" id=\"how_to_delete_wordpress_metadata_based_on_the_key\"><\/span>How to Delete WordPress Metadata Based on the Key?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Users<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_usermeta WHERE meta_key = \u2018job_title\u2019;<\/code><\/pre>\n\n\n\n<p>Posts<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_postmeta WHERE meta_key = \u2018post_rating\u2019;<\/code><\/pre>\n\n\n\n<p>Comments<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_commentmeta WHERE meta_key = \u2018comment_vote\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_wordpress_metadata_based_on_the_meta_value\"><span class=\"ez-toc-section\" id=\"how_to_find_wordpress_metadata_based_on_the_meta_value\"><\/span>How to Find WordPress Metadata Based on the meta_value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Refer to the section on how to find metadata based on meta_key. The only change is substituting the meta_value in place of the meta_key in the select queries.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_wordpress_metadata_based_on_the_meta_value\"><span class=\"ez-toc-section\" id=\"how_to_delete_wordpress_metadata_based_on_the_meta_value\"><\/span>How to Delete WordPress Metadata Based on the meta_value?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Refer to the section on how to find metadata based on meta_key. The only change is substituting the meta_value in place of the meta_key in the delete queries.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_wordpress_administrators\"><span class=\"ez-toc-section\" id=\"how_to_find_wordpress_administrators\"><\/span>How to Find WordPress Administrators?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Sometimes you\u2019ll encounter situations where there are unexpected users who have admin authority. Later, you\u2019ll want to remove them (after making a new admin user for yourself).<\/p>\n\n\n\n<p>Find Admins<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT * FROM wp_usermeta WHERE meta_value LIKE \u2018%administrator%\u2019;\n  SELECT * FROM wp_usermeta WHERE meta_key=\u2019wp_user_level\u2019 AND meta_value=\u201910\u2019;<\/code><\/pre>\n\n\n\n<p>This should display lists of admins and superadmins.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_remove_some_wordpress_administrators\"><span class=\"ez-toc-section\" id=\"how_to_remove_some_wordpress_administrators\"><\/span>How to Remove Some WordPress Administrators?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make sure that you have a valid admin\/superadmin login that works before proceeding.<\/p>\n\n\n\n<p>Run the query above in how to find WordPress administrators and make note of the results. Browse the wp_users table, highlight the admins to be removed and delete.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_remove_wordpress_users_with_no_posts_or_comments\"><span class=\"ez-toc-section\" id=\"how_to_remove_wordpress_users_with_no_posts_or_comments\"><\/span>How to Remove WordPress Users with No Posts or Comments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Make sure that you have made posts or comments with your admin accounts before running something like this!<\/p>\n\n\n\n<p>Run all three to clear users, meta and links associated with those users who are inactive. This from WPWhackedHelp.com:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_users WHERE ID&gt; 1 AND ID NOT IN \n    (SELECT DISTINCT post_author FROM wp_posts) AND ID NOT IN (SELECT DISTINCT user_id FROM wp_comments);\n  \n  DELETE FROM wp_usermeta WHERE user_id&gt; 1 AND user_id NOT IN \n    (SELECT DISTINCT post_author FROM wp_posts) AND user_id NOT IN \n      (SELECT DISTINCT user_id FROM wp_comments);\n\n  DELETE FROM wp_links WHERE link_owner&gt; 1 AND link_owner NOT IN \n    (SELECT DISTINCT post_author FROM wp_posts) AND link_owner NOT IN \n      (SELECT DISTINCT user_id FROM wp_comments);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_comments_and_comment_meta_without_joining_tables\"><span class=\"ez-toc-section\" id=\"how_to_delete_comments_and_comment_meta_without_joining_tables\"><\/span>How to Delete Comments and Comment Meta Without Joining Tables?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>A simple approach is to delete comments based on criteria, then delete all commentmeta that isn\u2019t associated with any comments. This works because the deleting of comments effectively makes commentmeta orphaned (an easy thing to spot in the database).<\/p>\n\n\n\n<p>Example &#8211; Deleting Comments Made Within a Date Range<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_date \n    BETWEEN '2000-01-01 00:00:00' AND '2019-01-01 00:00:00';<\/code><\/pre>\n\n\n\n<p>Then &#8211; Delete the Comment Meta of Orphaned Entries<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_commentmeta WHERE comment_ID NOT IN \n    (SELECT comment_ID FROM wp_comments);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_delete_comments_and_meta_made_within_a_date_range_alternative\"><\/span>How to Delete Comments and Meta Made Within a Date Range (alternative)?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments \n    WHERE comment_date &gt;= '2000-01-01 00:00:00' \n    AND comment_date &lt;= '2019-01-01 00:00:00';<\/code><\/pre>\n\n\n\n<p>Then &#8211; Delete the Comment Meta of Orphaned Entries<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_commentmeta WHERE comment_ID NOT IN \n    (SELECT comment_ID FROM wp_comments);<\/code><\/pre>\n\n\n\n<p><strong>Note:<\/strong>&nbsp;This alternative approach is the same as the example before it, since the MySQL between operator is inclusive.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_disable_comments_on_all_posts\"><span class=\"ez-toc-section\" id=\"how_to_disable_comments_on_all_posts\"><\/span>How to Disable Comments on All Posts?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>You can turn off comments within the WP admin section of WordPress or you can do it via a SQL one-liner. This one will turn off comments and pingbacks for all posts that have comments enabled.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed' \n  WHERE comment_status = 'open';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_disable_comments_only_on_older_posts\"><span class=\"ez-toc-section\" id=\"how_to_disable_comments_only_on_older_posts\"><\/span>How to Disable Comments Only on Older Posts?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>It\u2019s easy to turn off comments and pingbacks on older posts with this one-liner. Alternatively, you could set a date range as well.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_posts \n  SET comment_status = 'closed', ping_status = \u2018closed\u2019 \n  WHERE post_date &lt; '2019-10-10\u2019 AND post_status = 'publish\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_set_a_new_admin_password\"><span class=\"ez-toc-section\" id=\"how_to_set_a_new_admin_password\"><\/span>How to Set a New Admin Password?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>The below update statement assumes that you\u2019ll change the user_login to your adminusername, whatever that might be, and your new password to the \u2018whateverismynewpassword text below.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_users SET user_pass = MD5( 'whateverismynewpassword' ) \n  WHERE wp_users.user_login = \"adminusername\";<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_delete_all_approved_comments\"><span class=\"ez-toc-section\" id=\"how_to_delete_all_approved_comments\"><\/span>How to Delete All Approved Comments?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Not sure why they\u2019d all be approved, but hey &#8211; sometimes you need a massive cleaning.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_comments WHERE comment_approved = '1';<\/code><\/pre>\n\n\n\n<p>Then &#8211; Delete the Comment Meta of Orphaned Entries<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  DELETE FROM wp_commentmeta \n  WHERE comment_ID NOT IN \n    (SELECT comment_ID FROM wp_comments);<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_get_comment_counts_by_author\"><span class=\"ez-toc-section\" id=\"how_to_get_comment_counts_by_author\"><\/span>How to Get Comment Counts by Author?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>This one is handy for finding out who your most prolific commenters (or spammers) are &#8211; based on activity since the beginning of 2019.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT COUNT(*) AS comcount, comment_author, user_id FROM wp_comments\n  WHERE comment_approved = 1 AND comment_date &gt;= '2019-01-01'\n  GROUP BY user_id\n  ORDER BY comcount DESC;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\"><span class=\"ez-toc-section\" id=\"how_to_find_comment_spammers_by_activity_of_ip_address\"><\/span>How to Find Comment Spammers by Activity of IP Address?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT COUNT(*) AS comcount, comment_author, comment_author_IP \n  FROM wp_comments\n  WHERE comment_approved = 1 AND comment_date &gt; '2019-01-01'\n  GROUP BY comment_author_IP\n  ORDER BY comcount DESC<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_extract_contact_details_of_commenters_for_email_marketing_list_building\"><span class=\"ez-toc-section\" id=\"how_to_extract_contact_details_of_commenters_for_email_marketing_list_building\"><\/span>How to Extract Contact Details of Commenters for Email Marketing List Building?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Pull key contact details so you can use it in an email campaign.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT DISTINCT comment_author, comment_author_email\n  FROM wp_comments\n  WHERE comment_approved = 1\n  ORDER BY comment_author_email ASC<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_reset_wordpress_theme_to_default_when_site_is_crashing_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_reset_wordpress_theme_to_default_when_site_is_crashing_using_sql\"><\/span>How to Reset WordPress Theme to Default When Site is Crashing using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There can be times when things have gone horribly wrong with a theme, or theme plus plugins not cooperating, yielding crashes and problems that just don\u2019t seem to clear up.<\/p>\n\n\n\n<p>Resetting the default theme to Twenty Eleven using SQL is one way to get it loaded with something that should work. This is particularly handy when you can\u2019t login to the WordPress admin screens and need a way of getting things back to working properly.<\/p>\n\n\n\n<p>While just changing the template option may be enough, it\u2019s likely smarter to go ahead and set the stylesheet and current_theme as well, like so:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_options \n  SET option_value = 'Twenty Eleven' \n  WHERE option_name = 'template';\n  \n  UPDATE wp_options \n  SET option_value = 'twentyeleven' \n  WHERE option_name = 'stylesheet';\n  \n  UPDATE wp_options \n  SET option_value = 'twentyeleven' \n  WHERE option_name = 'current_theme';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_change_wordpress_pages_to_posts_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_change_wordpress_pages_to_posts_using_sql\"><\/span>How to Change WordPress Pages to Posts using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In case you\u2019ve inadvertently started off creating pages for all your content, thinking you were making posts, and would now like to change all those pages to posts, you can either do them all at once or one at a time with SQL.<\/p>\n\n\n\n<p>Change All Posts to Pages:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_posts \n  SET post_type = 'post' \n  WHERE post_type = 'page';<\/code><\/pre>\n\n\n\n<p>Change Only Certain Posts to Pages (replace 123 with the post ID you want changed):<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  UPDATE wp_posts \n  SET post_type = 'post' \n  WHERE post_type = 'page' and ID = \u2018123\u2019;<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"how_to_find_wordpress_category_id_via_category_name_using_sql\"><span class=\"ez-toc-section\" id=\"how_to_find_wordpress_category_id_via_category_name_using_sql\"><\/span>How to Find WordPress Category ID via Category Name using SQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>There are a dozen or more ways of doing this, but using the category name to get the ID isn\u2019t too terrible.<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  SELECT wp_term_taxonomy.term_taxonomy_id\n  FROM wp_term_taxonomy JOIN wp_terms ON (wp_term_taxonomy.term_id = wp_terms.term_id)\n  WHERE wp_term_taxonomy.taxonomy = 'category' AND wp_terms.name = 'yourcategoryname';<\/code><\/pre>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"when_setting_to_ping_or_pinged_in_wordpress_wp_posts_what_delimiter_should_be_used\"><span class=\"ez-toc-section\" id=\"when_setting_to_ping_or_pinged_in_wordpress_wp_posts_what_delimiter_should_be_used\"><\/span>When Setting to_ping or pinged in WordPress wp_posts, What Delimiter Should be Used?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>When loading a list of URLs into the database, they should be delimited by a \u201c\\n\u201d;<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_are_valid_post_types_in_wordpress\"><span class=\"ez-toc-section\" id=\"what_are_valid_post_types_in_wordpress\"><\/span>What are Valid Post Types in WordPress?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>In wp_posts, the post_type can be set to \u201cpost\u201d, \u201cpage\u201d or \u201cattachment\u201d, plus any additional user-defined types.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"what_4_languages_represent_the_database_commands_for_mysql\"><span class=\"ez-toc-section\" id=\"what_4_languages_represent_the_database_commands_for_mysql\"><\/span>What 4 Languages Represent the Database Commands for MySQL?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n\n\n\n<p>Data Definition Language or DDL<\/p>\n\n\n\n<p>The DDL is used in defining the database itself. DDL creates database schema and deals with database objects, like tables. With DDL, you can make wholesale changes:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  Alter - change the database structure and object definitions\n  Comment - create documentation for objects\n  Create - makes objects\n  Drop - removes objects\n  Rename - changes object name\n  Truncate - cleans out all records in a table<\/code><\/pre>\n\n\n\n<p>DDL works with objects such as:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  Functions\n  Indexes\n  Procedures\n  Tables\n  Triggers\n  Views<\/code><\/pre>\n\n\n\n<p>Data Manipulation Language or DML<\/p>\n\n\n\n<p>The DML comes into play when you manipulate the database data. With DML you can:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  Call - executes a stored procedure\n  Delete - remove rows from a table\n  Explain Plan - advises on how it will be handling a query request\n  Insert - add data to a table\n  Lock Table - prevents other potentially conflicting accesses to a table\n  Merge - Inserts\/Updates &#91;upserts] tables depending on keys\n  Update - modifies rows in a table<\/code><\/pre>\n\n\n\n<p>Data Control Language or DCL<\/p>\n\n\n\n<p>DCL is how you control which user has privileges to impact database objects. With DCL you can:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  Grant - give ability for user to do something \n  Revoke - withdraw ability for user to do something<\/code><\/pre>\n\n\n\n<p>Transaction Control Language or TCL<\/p>\n\n\n\n<p>TCL is for manipulating transactions. With TCL you can:<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code>  Commit - writes transaction data to the database since last commit or rollback\n  Rollack - undo transactions since last commit\/rollback\n  Savepoint - lets you pick a point where you can partially rollback to\n  Release Savepoint - removes savepoints\n  Set Transaction - names a transaction<\/code><\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>What&#8217;s the #1 Rule About Working with the WordPress Database \/ Tables? The most important WordPress rule is to backup the database before making changes! What&#8217;s the #2 Rule About Working with the WordPress Database \/ Tables? Make sure you work on the table you&#8217;re concerned with as well as the meta tables that contain [&hellip;]<\/p>\n","protected":false},"author":4,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[146],"tags":[251,252,258,255,106],"class_list":["post-1392","post","type-post","status-publish","format-standard","hentry","category-wordpress","tag-blogs","tag-cms","tag-phpmyadmin","tag-sql","tag-wordpress"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.5 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>WordPress Frequently Asked Questions - KnownHost<\/title>\n<meta name=\"description\" content=\"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"WordPress Frequently Asked Questions - KnownHost\" \/>\n<meta property=\"og:description\" content=\"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/\" \/>\n<meta property=\"og:site_name\" content=\"KnownHost\" \/>\n<meta property=\"article:published_time\" content=\"2021-07-26T11:32:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-11-22T12:51:23+00:00\" \/>\n<meta name=\"author\" content=\"Jonathan K. W.\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Jonathan K. W.\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/\"},\"author\":{\"name\":\"Jonathan K. W.\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"headline\":\"WordPress Frequently Asked Questions\",\"datePublished\":\"2021-07-26T11:32:22+00:00\",\"dateModified\":\"2021-11-22T12:51:23+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/\"},\"wordCount\":3286,\"keywords\":[\"blogs\",\"cms\",\"phpmyadmin\",\"SQL\",\"wordpress\"],\"articleSection\":[\"WordPress\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/\",\"name\":\"WordPress Frequently Asked Questions - KnownHost\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2021-07-26T11:32:22+00:00\",\"dateModified\":\"2021-11-22T12:51:23+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\"},\"description\":\"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/wordpress-frequently-asked-questions\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"WordPress Frequently Asked Questions\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/\",\"name\":\"KnownHost\",\"description\":\"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.knownhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/3db6e20d1f33519cd68fe0ba1230a48b\",\"name\":\"Jonathan K. W.\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g\",\"caption\":\"Jonathan K. W.\"},\"sameAs\":[\"https:\\\/\\\/www.knownhost.com\"]}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"WordPress Frequently Asked Questions - KnownHost","description":"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/","og_locale":"en_US","og_type":"article","og_title":"WordPress Frequently Asked Questions - KnownHost","og_description":"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.","og_url":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/","og_site_name":"KnownHost","article_published_time":"2021-07-26T11:32:22+00:00","article_modified_time":"2021-11-22T12:51:23+00:00","author":"Jonathan K. W.","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Jonathan K. W.","Est. reading time":"21 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#article","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/"},"author":{"name":"Jonathan K. W.","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"headline":"WordPress Frequently Asked Questions","datePublished":"2021-07-26T11:32:22+00:00","dateModified":"2021-11-22T12:51:23+00:00","mainEntityOfPage":{"@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/"},"wordCount":3286,"keywords":["blogs","cms","phpmyadmin","SQL","wordpress"],"articleSection":["WordPress"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/","url":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/","name":"WordPress Frequently Asked Questions - KnownHost","isPartOf":{"@id":"https:\/\/www.knownhost.com\/kb\/#website"},"datePublished":"2021-07-26T11:32:22+00:00","dateModified":"2021-11-22T12:51:23+00:00","author":{"@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b"},"description":"Do you have questions and looking for answers? Read inside to see a list of frequently asked WordPress questions, and our answers.","breadcrumb":{"@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.knownhost.com\/kb\/wordpress-frequently-asked-questions\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.knownhost.com\/kb\/"},{"@type":"ListItem","position":2,"name":"WordPress Frequently Asked Questions"}]},{"@type":"WebSite","@id":"https:\/\/www.knownhost.com\/kb\/#website","url":"https:\/\/www.knownhost.com\/kb\/","name":"KnownHost","description":"KnownHost provides a comprehensive webhosting knowledge base to help answer many of your common webhosting and linux questions.","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.knownhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.knownhost.com\/kb\/#\/schema\/person\/3db6e20d1f33519cd68fe0ba1230a48b","name":"Jonathan K. W.","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f432b99e6651fe8d1deb57a285bd84e806f1c9ae8b4c6c585d7e3a0b33789ad9?s=96&d=mm&r=g","caption":"Jonathan K. W."},"sameAs":["https:\/\/www.knownhost.com"]}]}},"_links":{"self":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1392","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/comments?post=1392"}],"version-history":[{"count":0,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/posts\/1392\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/media?parent=1392"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/categories?post=1392"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.knownhost.com\/kb\/wp-json\/wp\/v2\/tags?post=1392"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}