how do I query "SHOW xxx"

Database

how do I query "SHOW xxx"

I'd like to process the results of a show command in a stored proc.
Can I create a query on 'SHOW xxx' somehow?

Thanks