SHOW (more than one) VARIABLES

Question

How do you use more than a single LIKE in a single SHOW VARIABLES query in MySQL?

Answer 1

show variables where Variable_name like 'tmp%' or Variable_name like 'max%';

http://dev.mysql.com/doc/refman/5.0/en/show-variables.html

Answer 2

If you are using MySQL 5.1+, you can query the INFORMATION_SCHEMA

SELECT * FROM information_schema.global_variables
WHERE variable_name LIKE 'tmp%' or variable_name like 'max%';