show variables - Unknown column 'value' in 'where clause' In mysql I ran the below:

mysql&gt; SHOW VARIABLES where variable_name = 'character_set_database';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| character_set_database | utf8  |
+------------------------+-------+
1 row in set (0.32 sec)

mysql&gt; SHOW VARIABLES where variable_name = 'character_set_database' and value = 'utf8';
ERROR 1054 (42S22): Unknown column 'value' in 'where clause'


Why does the above happen?
SHOW does not have that syntax.  Simply do

SHOW VARIABLES LIKE 'character_set_database';


and don't include the 'value'.