SELECT ... WHERE substring(ip_addr::text, 1, 10) = '172.23.110'
or
select ... where ip_addr << '172.23.110/32';
/32 is for one address only (fourth byte, which we want to exclude), so we need to use /24 (as for CIDR notation), that would be equal to a 255.255.255.0 subnet mask.