指着他活着呢

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';

原文地址:https://www.cnblogs.com/niehaidong111/p/10286339.html