Skip to main content

Documentation Index

Fetch the complete documentation index at: https://docs.w22.dev/llms.txt

Use this file to discover all available pages before exploring further.

MySQL UI gives you three tools to narrow down what you see in the data view: sorting by column, full-text search, and column filters. You can use all three at the same time, and they apply instantly without reloading the page.

​
Sorting

Click any column header to sort the table by that column. Clicking the same header cycles through three states:
  1. Ascending (↑) — lowest to highest, A to Z, oldest to newest
  2. Descending (↓) — highest to lowest, Z to A, newest to oldest
  3. No sort — returns to the default order
Only one column can be sorted at a time. Sorting a new column removes the previous sort. Type in the Search across text columns… bar in the toolbar and press Enter to search. MySQL UI scans all text-based columns in the table and returns rows that contain your search term in any of them. To clear an active search, click the × button that appears inside the search bar, or delete the text and press Enter.

​
Filters

Filters let you build precise conditions on any column. Click the Filters button in the toolbar to open the filter dialog.

​
Adding a filter

  1. Click Add Filter in the dialog.
  2. Choose a column from the first dropdown.
  3. Choose an operator from the second dropdown.
  4. Enter a value in the text field (not required for IS NULL and IS NOT NULL).
  5. Repeat to add more filters, then click Apply Filters.
The available operators are:
OperatorMeaning
=Exactly equals
!=Does not equal
>Greater than
<Less than
>=Greater than or equal to
<=Less than or equal to
LIKEContains (use % as a wildcard)
NOT LIKEDoes not contain
IS NULLField is empty / null
IS NOT NULLField has any value
INMatches any value in a comma-separated list

​
Managing active filters

Active filters appear as badges below the toolbar, showing the column, operator, and value for each condition. To remove a single filter, click the × on its badge. To remove all filters at once, click Clear all at the end of the badge row. The Filters button also shows a count badge (for example, Filters 2) so you can see at a glance how many conditions are active.
Combine multiple filters to answer questions like “show me all orders where status = ‘pending’ AND total >= 100” without writing any SQL. Add one filter per condition and click Apply Filters to see the results immediately.