select from table programatically in mysql

Need something where I can select from a table using a function.

Example:

SELECT * FROM HEX(UNHEX('users')) which should select from a table called “users”

This is just an example but the general idea is I want to be able to use functions to define what table I select from. Or maybe an alternative?