SHOW Syntax Overview

The SHOW syntax is used to view information about database objects. The LIKE clause is used to filter database objects. The following lists the matching rules. For details, see SHOW TABLES.

Rule 1: Underscores (_) can be used to match any single character.

Rule 2: Percent signs (%) can be used to match zero or any number of characters.

Rule 3: Asterisks (*) can be used to match zero or any number of characters.

Rule 4: Vertical bars (|) can be used to separate multiple rules.

Rule 5: To use an underscore (_) as a matching condition, use ESCAPE to specify an escape character to escape the underscore (_) so that it will not be parsed according to rule 1.