> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/reference/sql-statements/administrative-sql-statements/show/extended-show.md).

# Extended SHOW

The following [SHOW](/docs/server/reference/sql-statements/administrative-sql-statements/show.md) statements can be extended using a `WHERE` clause and a `LIKE` clause to refine the results:

* [SHOW CHARACTER SET](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-character-set.md)
* [SHOW COLLATION](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-collation.md)
* [SHOW COLUMNS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-columns.md)
* [SHOW DATABASES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-databases.md)
* [SHOW FUNCTION STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-function-status.md)
* [SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md)\`\`
* [SHOW OPEN TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-open-tables.md)
* [SHOW PACKAGE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-status.md)
* [SHOW PACKAGE BODY STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-package-body-status.md)
* [SHOW INDEX](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-index.md)
* [SHOW PROCEDURE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-procedure-status.md)
* [SHOW STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-status.md)
* [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md)
* [SHOW TABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-tables.md)
* [SHOW TRIGGERS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-triggers.md)
* [SHOW VARIABLES](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-variables.md)

As with a regular [SELECT](/docs/server/reference/sql-statements/data-manipulation/selecting-data/select.md), the `WHERE` clause can be used for the specific columns returned, and the [LIKE](/docs/server/reference/sql-functions/string-functions/like.md) clause with the regular wildcards.

## Examples

This statement shows all tables:

```sql
SHOW TABLES;
+----------------------+
| Tables_in_test       |
+----------------------+
| animal_count         |
| animals              |
| are_the_mooses_loose |
| aria_test2           |
| t1                   |
| view1                |
+----------------------+
```

This statement only shows tables starting with the letter 'a':

```sql
SHOW TABLES WHERE Tables_in_test LIKE 'a%';
+----------------------+
| Tables_in_test       |
+----------------------+
| animal_count         |
| animals              |
| are_the_mooses_loose |
| aria_test2           |
+----------------------+
```

This statement shows variables whose names start with *aria* and have a value greater than 8192:

```sql
SHOW VARIABLES WHERE Variable_name LIKE 'aria%' AND Value >8192;
+------------------------------+---------------------+
| Variable_name                | Value               |
+------------------------------+---------------------+
| aria_checkpoint_log_activity | 1048576             |
| aria_log_file_size           | 1073741824          |
| aria_max_sort_file_size      | 9223372036853727232 |
| aria_pagecache_buffer_size   | 134217728           |
| aria_sort_buffer_size        | 134217728           |
+------------------------------+---------------------+
```

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}