如何在MySQL过程中获取ENUM的值

CREATE TABLE `FrameworkServices` (
  ...
  `DNSType` enum(\'IP\',\'CNAME\') NOT NULL,
  ...
)

SELECT DNSType, CNameOrIP INTO @hackEnum, @ipAddress
FROM FrameworkServices WHERE FrameworkTypeId = 1 LIMIT 1;
SELECT @hackEnum, @ipAddress;

IF...ELSE...END IF

DECLARE use_free CHAR(1);

SELECT use_free INTO use_free FROM ...;

IF use_free = \'1\' THEN
  <do something>
ELSE
  <do something else>
END IF;

DECLARE use_free ENUM(\'0\',\'1\');

CREATE TABLE `FrameworkServices` (
  ...
  `DNSType` enum(\'IP\',\'CNAME\') NOT NULL,
  ...
)

declare valor varchar(40);
select DNSType from FrameworkServices into valor;