SELECT a.id, a.`full_name`, a.`category`, bin(a.`category`),
substr(REVERSE(LPAD(bin(a.`category`), 20, '0')), 7, 1) 是否,
REVERSE(LPAD(bin(a.`category`), 20, '0'))
FROM `appliter`.`aws_advisor_info` a
HAVING 是否 = '1';
SELECT a.id, a.`full_name`, a.`category`, bin(a.`category`),
substr(REVERSE(LPAD(bin(a.`category`), 20, '0')), 7, 1) 是否,
REVERSE(LPAD(bin(a.`category`), 20, '0'))
FROM `appliter`.`aws_advisor_info` a
HAVING 是否 = '1';