> ## Documentation Index
> Fetch the complete documentation index at: https://help.noxity.io/llms.txt
> Use this file to discover all available pages before exploring further.
# Browse Tables and Data
> Open a table, page through rows, filter, sort, and edit values inline in phpMyAdmin.
The most common thing you'll do in phpMyAdmin is open a table and look at the data. Maybe edit a row, maybe filter to find a specific record. Everything starts from the **Browse** tab.
## The layout
| Area | What it shows |
| -------------- | --------------------------------------------------------------------------------------------------- |
| Left tree | All your databases. Click to expand into tables. |
| Top tabs | **Browse**, **Structure**, **SQL**, **Search**, **Insert**, **Export**, **Import**, **Operations**. |
| Main pane | Whatever the active tab is showing. On Browse, that's the rows. |
| Below the rows | Pagination controls and per-page row count. |
## Open a table
Click the database name to expand it. The tables inside appear underneath, indented.
The Browse tab opens by default and shows the first 25 rows.
Use the arrows below the table or change the page size. Setting **Show:** to 100 or 500 is faster than clicking through pages when you're scanning.
## Edit a row in place
The row opens in an inline edit form with one field per column.
For text columns, type the new value. For dates, the field accepts MySQL date format (`2026-04-27 14:30:00`). For NULL, click the **Null** checkbox.
The row updates. The SQL it just ran is shown above the result, so you can see exactly what happened.
To edit several rows at once, check the boxes on the left and click **With selected: Edit**. phpMyAdmin opens all of them in one form.
## Filter rows without writing SQL
The Browse tab has a small **Filter rows** box at the top. Type a value and it filters case-insensitively across all visible columns. Useful for quick lookups.
For anything more structured, use the **Search** tab. It lets you build per-column conditions through dropdowns.
For complex joins or aggregates, switch to the [SQL tab](/web-hosting/cpanel/database-management/phpmyadmin/sql). That's what it's for.
## Sort by a column
Click the column header. First click is ascending, second is descending, third removes the sort. The arrow next to the header shows the direction.
To sort by multiple columns at once, hold `Shift` and click each header in priority order.
## Delete rows
Deletes are permanent. Take a backup of the table first via [Export](/web-hosting/cpanel/database-management/phpmyadmin/export) → **Custom** → **Add DROP TABLE** if it's anything important.
To delete one row, click the red **X** icon at the row's left edge and confirm.
To delete several rows, check the boxes on the left and click **With selected: Delete**.
To delete everything in the table without deleting the table itself, go to the [Operations tab](/web-hosting/cpanel/database-management/phpmyadmin/table-operations) and click **Empty the table (TRUNCATE)**. This is faster than `DELETE FROM ...` for large tables.
## Need a hand?
Best for anything that needs an account check or a config change on our end.
Faster for quick questions during business hours.