MySQL: To check multiple variables or parameters

 To check multiple variables at once:

Sql
WHERE gv.VARIABLE_NAME IN ('sql_mode', 'max_connections', 'time_zone');

To search by pattern:

Sql
WHERE gv.VARIABLE_NAME LIKE 'innodb%';