select * from table where mac_address like '%:%:%:%:%:%'
and (length(mac_address)) = 17
and mac_address like '^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$'
select * from table where mac_address like '%:%:%:%:%:%'
AND (length(mac_address)) = 17
AND mac_address ~ '^([0-9A-Fa-f]{2}[:-]){5}([0-9A-Fa-f]{2})$'
limit 100;