INSERT INTO `dim_domain_info`(`id`, `domain`, `ip`, `port`) VALUES (27916, 'aa.edu1.cn', '1.2.9.1', 443);
INSERT INTO `dim_domain_info`(`id`, `domain`, `ip`, `port`) VALUES (27917, 'aa.edu1.cn', '1.2.9.1', 80);
使用:
select * from dim_domain_info where port in ('80,443');
则只能查询到80的
select * from dim_domain_info where FIND_IN_SET(port,'80,443');