MySQL: OR in SHOW TABLES?
SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' 
  AND TABLE_NAME IN ('TABLES', 'SCHEMATA');


or, for example (6 tables will be shown)

SELECT TABLE_NAME 
FROM INFORMATION_SCHEMA.TABLES 
WHERE TABLE_SCHEMA = 'INFORMATION_SCHEMA' 
  AND (    TABLE_NAME LIKE 'TABLE%'
        OR TABLE_NAME LIKE 'SCHEMA%' );