gistfile1.sql

DELIMITER // 
CREATE PROCEDURE GetAllValues(ColName VARCHAR(255))
BEGIN 
SELECT
  COLUMN_NAME, TABLE_NAME
FROM
  INFORMATION_SCHEMA.COLUMNS
WHERE
  TABLE_SCHEMA = DATABASE()
AND
  COLUMN_NAME = 'ColName';

END // 
DELIMITER ;