mysql 字符串截取

SELECT

FROM
r_int_port_detail
WHERE SUBSTRING_INDEX(internet_address,'/',1) = '61.49.xxx.xxx'

表里 internet_address 字段数据为 61.49.xxx.xxx/30