Quick wins for a faster PC:
Repair Windows errors before they cause bigger problemsFix Now →Scan for outdated or missing drivers - takes under a minuteDriver Scan →To run a SQL query for WordPress, open phpMyAdmin from your hosting control panel, select the site’s database in the left column, open SQL, paste or type the statement, and choose Go (or press Ctrl+Enter). Back up the database first, confirm the table prefix in wp-config.php, and inspect every UPDATE, DELETE, DROP, or other write operation before executing it.
Antihost offers managed WordPress hosting with free migration, one-click staging and a 14-day free trial.
phpMyAdmin is useful when WordPress is unavailable or when a database maintenance task is more practical than using the dashboard. It gives you direct access to the tables, so a typo or an incorrect database selection can affect the entire site. The procedure below separates safe read-only checks from changes and explains how to recover when the interface blocks a query.
As an Amazon Associate I earn from qualifying purchases.
What you need before opening phpMyAdmin
Have these items ready before you run anything:
- Access to the hosting control panel that launches phpMyAdmin.
- The database name and credentials used by this WordPress installation, normally recorded in
wp-config.php. - A recent database export stored somewhere other than the server.
- A maintenance window if a change could alter visible content, logins, settings, orders, or other live data.
- A text copy of the exact SQL you intend to run, including its
WHEREclause.
The WordPress Developer Handbook describes phpMyAdmin as a tool for table maintenance, backups, and direct edits when WordPress itself is not working. phpMyAdmin’s introduction also notes that it can execute, edit, and bookmark individual or batch SQL statements. Those capabilities are powerful, but phpMyAdmin does not understand your business intent: it will execute a syntactically valid command against whichever database and tables you selected.
Back up the database first
- Open phpMyAdmin from your hosting panel.
- Select the WordPress database in the left column.
- Open the Export tab.
- Use the normal or quick export option offered by your installation and SQL format when those choices are shown.
- Download the resulting file and record the date, site, and database name in the filename.
- Keep the export off the web server. Treat it as sensitive because it can contain user accounts, email addresses, session data, and site content.
If a query damages data, the export is your rollback source. A hosting snapshot or automated backup can provide an additional recovery path, but do not assume that a backup exists or is restorable until you know how to retrieve it.
#1 Best Overall
- Read Before You Buy — No Video Output: These adapters support charging and USB 2.0 data transfer, but cannot transmit video signals. Except for standard USB webcams (which use USB data only), they are not compatible with HDMI/DisplayPort cables, video-capable USB-C hubs, or docking stations with video output.
- Convert USB-A Ports to USB-C: Designed to connect USB-C earphones, cables, flash drives, card readers, and other USB-C accessories to standard USB-A ports. Plug-and-play with no drivers or software required.
- Aluminum Alloy Housing: Built with a sturdy aluminum alloy shell that aids in heat dissipation and protects against daily wear and scratches. Designed to maintain a stable and secure connection.
- Compact & Travel-Friendly: The ultra-compact design allows the adapter to stay plugged into your device without blocking adjacent ports or adding bulk, reducing wear and tear on your original USB ports.
- 12-Month Warranty: Backed by a 12-month manufacturer warranty for peace of mind. Designed to meet strict quality control standards for reliable everyday performance.
Confirm the table prefix
WordPress installations do not all use the default wp_ prefix. Open wp-config.php through your host’s file manager or SFTP and find the value assigned to $table_prefix. If it is site9_, for example, the posts table is site9_posts, not wp_posts. Use the exact prefix in every query. A wrong prefix normally produces a “table doesn’t exist” error; a copied prefix from another site can be much worse because it may target a real, unrelated table.
Open the correct database and SQL editor
- Sign in to the hosting control panel and launch phpMyAdmin. The location and label differ by hosting provider.
- In phpMyAdmin’s left navigation, identify the database used by this WordPress site. If several databases are listed, match the name shown in
wp-config.php. - Click the database name. Its tables should appear in the navigation or main panel.
- Choose the SQL tab in the main panel.
- Before typing, check the database name displayed above the SQL text area. This is the last convenient opportunity to catch a wrong selection.
- Enter or paste one statement, or a deliberately prepared batch, into the editor.
- Click Go. phpMyAdmin displays a result set, an affected-row message, or an error on the next page.
Do not open the SQL tab first and rely on memory to select a database afterward. The selected database controls where unqualified table names are resolved. If the database name shown above the editor is not the one you expect, stop and select the correct database.
Free tools Windows power users keep installed
One-click scans. No signup required.
Run a read-only query first
A SELECT statement reads data without changing it and is the safest way to verify the prefix, columns, and filter you plan to use. For a standard installation using the default prefix, this query lists published posts newest first:
SELECT *
FROM wp_posts
WHERE post_status = 'publish'
ORDER BY post_date DESC;Replace wp_ with the value from wp-config.php. The query shown in BlogVault’s example follows this same pattern. If the result contains the expected site’s posts, you have confirmed both the database selection and the table name.
Limit the amount of data returned
On a large site, avoid opening every row while developing a query. Add a limit while you inspect the result:
SELECT ID, post_date, post_title, post_status
FROM wp_posts
WHERE post_status = 'publish'
ORDER BY post_date DESC
LIMIT 20;After replacing the prefix, check that the titles and dates belong to the site you intend to administer. Remove or adjust the limit only after the filter is proven. Selecting specific columns also makes it easier to spot an accidental match than displaying a very wide row.
Do these 3 things before closing this tab:
1Scan for outdated or missing drivers - takes under a minute2Repair Windows errors before they cause bigger problems3Fix the driver behind crashes, sound loss and screen glitchesRank #2
- 5-in-1 USB-C Hub: Experience comprehensive connectivity featuring a Power Delivery input, two USB-A 2.0 ports, a USB-A 3.0 port, and an HDMI port. (Note: The USB-C power delivery input port is only for connecting an external wall charger to power your laptop and cannot power peripheral devices.)
- 90W Pass-Through Charging: Achieve optimal charging with 90W pass-through power to your laptop, supported by a total input of 100W, with the hub reserving 10W for operational efficiency. (Note: Wall charger not included.)
- Quick Data Transfers: Accelerate your productivity with rapid data transfers using a high-speed 5Gbps USB 3.0 port and two 480Mbps USB 2.0 ports.
- 4K HDMI Display: Enhance your visual experience with a hub capable of delivering 4K resolution at 30Hz in both mirror and extend modes. Please note that this hub is compatible with MacBook (macOS 12 and newer), Windows 10 and 11, ChromeOS, and laptops equipped with DP Alt Mode and Power Delivery. Note: This device is not compatible with Linux.
- What You Get: Anker USB-C Hub (5-in-1, 4K HDMI), welcome guide, 18-month warranty, and our friendly customer service.
Execute with the keyboard
In phpMyAdmin documentation, Ctrl+Enter is the default shortcut for executing the SQL in the editor. Shift+Enter inserts a new line. The configuration reference for phpMyAdmin 5.1.4 lists ConsoleEnterExecutes as false by default, so pressing Enter alone should not be treated as an execution command. Use the visible Go button if you are unsure which keyboard settings your host has enabled.
Useful WordPress queries and how to adapt them
These examples are deliberately read-only unless marked otherwise. Replace the prefix in every table name and test each filter with a SELECT before changing data.
Find posts by title text
SELECT ID, post_date, post_title, post_status
FROM wp_posts
WHERE post_title LIKE '%migration%'
ORDER BY post_date DESC;The percent signs are wildcards. This search can match many rows, so review the IDs and statuses before using an ID in another command.
Inspect custom fields for one post
SELECT meta_id, post_id, meta_key, meta_value
FROM wp_postmeta
WHERE post_id = 123
ORDER BY meta_key;Change 123 only after confirming the post ID. Long serialized values may be difficult to edit safely by hand; changing a serialized PHP value without updating its length metadata can break the option or custom field that stores it.
What’s actually slowing this PC down?
Pick the symptom - the matching free tool is one click away.
Count content by status
SELECT post_status, COUNT(*) AS total
FROM wp_posts
WHERE post_type = 'post'
GROUP BY post_status;This is a quick consistency check when the dashboard’s counts look wrong. It counts rows in the selected table; it does not validate whether a plugin has additional rules for displaying them.
Inspect site options
SELECT option_name, option_value
FROM wp_options
WHERE option_name IN ('siteurl', 'home');These values control important URL settings. Read them first and record the original values. A URL replacement across all tables is not a safe blind search-and-replace because serialized data, GUIDs, and plugin-specific formats require different handling.
Rank #3
- Sleek 7-in-1 USB-C Hub: Features an HDMI port, two USB-A 3.0 ports, and a USB-C data port, each providing 5Gbps transfer speeds. It also includes a USB-C PD input port for charging up to 100W and dual SD and TF card slots, all in a compact design.
- Flawless 4K@60Hz Video with HDMI: Delivers exceptional clarity and smoothness with its 4K@60Hz HDMI port, making it ideal for high-definition presentations and entertainment. (Note: Only the HDMI port supports video projection; the USB-C port is for data transfer only.)
- Double Up on Efficiency: The two USB-A 3.0 ports and a USB-C port support a fast 5Gbps data rate, significantly boosting your transfer speeds and improving productivity.
- Fast and Reliable 85W Charging: Offers high-capacity, speedy charging for laptops up to 85W, so you spend less time tethered to an outlet and more time being productive.
- What You Get: Anker USB-C Hub (7-in-1), welcome guide, 18-month warranty, and our friendly customer service.
Changing data: test, constrain, then execute
Any statement that writes, deletes, or changes a table deserves a separate review. The key safeguards are a current export, an exact filter, and a preview query that returns the rows to be changed.
Preview an update
Suppose you need to change a post’s status. First preview the target:
SELECT ID, post_title, post_status
FROM wp_posts
WHERE ID = 123;Only when the returned row is the intended post should you consider the corresponding update:
UPDATE wp_posts
SET post_status = 'draft'
WHERE ID = 123;After phpMyAdmin reports the affected-row count, run the same SELECT again. If the count is zero, the condition matched nothing; if it is higher than expected, stop and restore from your backup rather than issuing another corrective command blindly.
Use a narrow condition for bulk changes
A condition such as WHERE post_status = 'publish' can match thousands of rows. Add a post type, date range, author, or an explicit ID list when your task allows it. Never remove the WHERE clause merely to “make the query work.” In SQL, an UPDATE or DELETE without a WHERE clause applies to every row in the table.
Understand destructive statements
| Statement | Effect | Check before clicking Go |
|---|---|---|
SELECT |
Reads rows; does not intentionally change them. | Database, table, columns, and filter. |
INSERT |
Adds rows and can create duplicate or orphaned records. | Required columns, unique keys, and relationships. |
UPDATE |
Changes matching rows. | Run the equivalent SELECT and verify the affected-row scope. |
DELETE |
Removes matching rows, often permanently. | Export, exact IDs, and a second-person review for production data. |
TRUNCATE |
Removes all rows from a table. | Confirm that the entire table is disposable; do not use it as a routine cleanup shortcut. |
DROP |
Removes a table or other database object. | Verify the database and object name character by character. Destructive commands such as DROP require an explicit double-check. |
WordPress tables are related through IDs and metadata rather than a single “record.” Deleting a post row without considering its post metadata, taxonomy relationships, revisions, comments, or plugin-owned tables can leave orphaned data or break features. Prefer WordPress-supported tools or a plugin’s documented cleanup procedure when one exists.
Rank #4
- Dual Converters, Infinite Potential：Includes 2× USB C male to USB A female adapters and 2× USB A male to USB C female adapters. Perfect for a wide range of uses—tablets with Bluetooth keyboards, expand USB ports on macbook, and more. Two different converters for all your daily needs
- Next-Level 10Gbps & 3A Charging: No more slow 480Mbps, this usb to usb c adapter has a transfer speed of up to 10Gbps, allowing you to do more transferring in less time. This usb adapter fits both USB A and USB C charger, supporting up to 3A fast charging
- Upgraded Exquisite Craftsmanship: With an aluminum alloy housing and metal connector, the usbc to usb adapter is extremely durable and sturdy. Rigorously tested to withstand more than 10,000 times of plugging and unplugging, ensuring long-lasting performance
- Broad Compatible: The usb c to usb adapter widely supports all USB C/ USB A devices like laptops, tablets, cellphones, car chargers, and phone chargers. Such as compatible with MacBook Pro/Air 2023/2022, Thunderbolt 4/3 Devices,Apple MagSafe Watch 9/8/7/SE/Ultra, iPad Pro 2022/2021, Samsung Galaxy S23/S20/S10, and iPhone 17/16/15 Pro. Plug and play
- Please Note: To reach 10Gbps speed, keep the cable under 3.3 ft. For USB A Male to USB C adapters, try flipping the USB C connector. USB C Male to USB A adapters support bidirectional 10Gbps transfer within 3.3 ft
Use parameters for repeatable queries
From phpMyAdmin 4.5, the SQL page accepts parameters written with a colon prefix. If you tick Bind parameters, phpMyAdmin displays fields for those values. This is useful when you need to run the same statement for different IDs or statuses without editing the SQL text each time.
SELECT ID, post_title, post_status
FROM wp_posts
WHERE post_status = :status
ORDER BY post_date DESC;With Bind parameters enabled, enter a value such as publish in the generated input field and execute the query. Parameter binding does not choose the database or table for you, and it does not make a destructive statement safe. Continue to verify the prefix and review the statement itself.
Read phpMyAdmin’s result and error messages
“Table doesn’t exist”
Check the selected database and the prefix in wp-config.php. A multisite network may use the same prefix with numbered table names, while plugins may create their own tables. Do not create a replacement table just to suppress the error; first identify the table that the site actually uses.
“Unknown column”
Column names vary by table and WordPress version or plugin. Run a small SELECT against the table, inspect its structure in phpMyAdmin, and copy the exact column name. Do not infer a column from a similarly named table.
Outdated Drivers Are Slowing You Down
One free scan finds every outdated or missing driver and matches the right update for your exact hardware.Free scan · exact hardware matchWindows Errors? Fix Them Before They Spread
Repair common Windows errors and clear accumulated junk for a smoother, more stable PC - no reinstall needed.Free scan · no reinstallSyntax errors
Look for a missing comma, quote, parenthesis, or semicolon. Text values require matching quotes. If you pasted a batch, isolate one statement and run it alone. A syntax error means that statement did not execute; it does not prove that an earlier statement in a batch was harmless, so inspect the messages for each statement.
Zero rows or an unexpected result
Check spelling, capitalization rules for the column’s collation, date format, post type, and status. Remove joins and extra conditions temporarily, then add them back one at a time. Never “fix” an empty result by broadening a write query before you know why the filter missed.
Best Value
- 5-in-1 Connectivity: Equipped with a 4K HDMI port, a 5 Gbps USB-C data port, two 5 Gbps USB-A ports, and a USB C 100W PD-IN port. Note: The USB C 100W PD-IN port supports only charging and does not support data transfer devices such as headphones or speakers.
- Powerful Pass-Through Charging: Supports up to 85W pass-through charging so you can power up your laptop while you use the hub. Note: Pass-through charging requires a charger (not included). Note: To achieve full power for iPad, we recommend using a 45W wall charger.
- Transfer Files in Seconds: Move files to and from your laptop at speeds of up to 5 Gbps via the USB-C and USB-A data ports. Note: The USB C 5Gbps Data port does not support video output.
- HD Display: Connect to the HDMI port to stream or mirror content to an external monitor in resolutions of up to 4K@30Hz. Note: The USB-C ports do not support video output.
- What You Get: Anker 332 USB-C Hub (5-in-1), welcome guide, our worry-free 18-month warranty, and friendly customer service.
When a firewall blocks the query
A web application firewall can display an “unsafe operation” warning and block phpMyAdmin requests. The phpMyAdmin FAQ describes allowing phpMyAdmin scripts in the firewall or disabling the firewall for the phpMyAdmin path as possible remedies. Use the narrowest exception your host supports, only for the maintenance window, and re-enable protection afterward.
If you cannot change the firewall rule, contact the host and provide the time of the request, the phpMyAdmin path, and the non-destructive query you were trying to run. Do not repeatedly retry a blocked destructive command: each retry can create confusing logs and, if one request eventually passes, an unexpected change.
Recommended Free Tools
Batch queries and transactions
phpMyAdmin can execute batch SQL, but batching increases the cost of a mistake. Keep exploratory work as separate statements so you can inspect each result. If you use a batch for a planned migration, put comments above each statement, list the expected affected-row count, and keep the backup next to the migration notes.
Whether transaction commands provide protection depends on the storage engine and the statements involved. A transaction is not a substitute for an export: some operations commit implicitly, and a later application request may modify the same rows. Treat the export as the durable rollback plan and verify the post-change state with read-only queries.
Security and access hygiene
- Use an HTTPS control-panel session and sign out when finished.
- Do not paste database passwords or full exports into tickets, chat, or public documentation.
- Remove downloaded exports from web-accessible directories.
- Limit phpMyAdmin access to trusted administrators and use the host’s current authentication controls.
- Record the exact query, date, database, and affected-row count for any production change.
Because SQL bypasses WordPress’s normal validation and permission checks, a successful query can change data that no user role could alter in the dashboard. Apply the same change-management discipline you would use for code deployed to production.
Using WordPress code instead of phpMyAdmin
When the task belongs in a repeatable plugin, theme, command-line script, or deployment process, WordPress’s wpdb class provides a query() method that executes SQL against the WordPress database. This approach can place the operation under version control and application logging, but it still requires a constrained query, correct table names, and backup planning. Do not move an unsafe statement into PHP and assume the language makes it safe.
A final pre-flight checklist
- Confirm the site and database name from
wp-config.php. - Confirm the exact table prefix; never assume
wp_. - Export the database and verify that the file downloaded successfully.
- Select the database in phpMyAdmin’s left column.
- Open SQL and re-check the database name above the editor.
- Run a read-only
SELECTthat previews the rows. - Check every quote, ID, table name, and
WHEREclause. - For
UPDATE,DELETE,TRUNCATE, orDROP, confirm the expected scope and affected-row count. - Click Go or use Ctrl+Enter, then read the complete result or error page.
- Run a verification
SELECTand document what changed.
The Bottom Line
The safe workflow is simple: back up first, select the verified WordPress database, confirm its real table prefix, test with SELECT, and only then execute a narrowly scoped change. phpMyAdmin’s Go button and Ctrl+Enter shortcut run the query, but neither can protect you from choosing the wrong database or issuing an over-broad command.
Quick Recap
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
