Possible to select individual values using SHOW STATUS in MySQL? -

is possible write query return value of variable returned mysql's show status? ideally want like:

select `value` (show status 'com_delete')

or similar.

is possible?

if using mysql 5.1 or above, should able data information_schema global status:

select variable_value  information_schema.global_status  variable_name = 'com_delete';

or if want session status instead:

select variable_value  information_schema.session_status  variable_name = 'com_delete';

the default show status session status, latter query work replacement that.

shell