MySQL Parser: SHOW TABLES LIKE 'pattern'is not supported

Describe the bug

The parser currently does not support the SHOW TABLES LIKE 'pattern' syntax, which is a standard MySQL statement. Attempting to parse it results in a syntax error.

To Reproduce

Steps to reproduce the behavior:

1. Use the following code snippet:

const { Parser } = require('node-sql-parser');

const parser = new Parser();

try {

const ast = parser.astify("SHOW TABLES LIKE 'user%'", { database: 'mysql' });

console.log(ast);

} catch (error) {

console.error(error.message);

}

2. Actual Output: Throws an error: Expected "#", "--", "/*", ";", "GO", [ \t\n\r], or end of input but "L" found.
3. Expected Output: Should successfully parse and return an AST object for the SHOW TABLES statement.

Additional context

• Library Version: Latest
• Database Dialect: MySQL / MariaDB
• Standard SQL: SHOW TABLES [LIKE 'pattern'] is a common DDL statement for listing tables.

Feature Request

Please extend the grammar to support SHOW TABLES with optional LIKE clause. This is critical for projects that need to parse database introspection queries.