On this page

Show all

SHOW Syntax Overview

Updated on 2022-11-18 GMT+08:00

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback