SELECT
FROM
r_int_port_detail
WHERE SUBSTRING_INDEX(internet_address,'/',1) = '61.49.xxx.xxx'
表里 internet_address 字段数据为 61.49.xxx.xxx/30
SELECT
FROM
r_int_port_detail
WHERE SUBSTRING_INDEX(internet_address,'/',1) = '61.49.xxx.xxx'
表里 internet_address 字段数据为 61.49.xxx.xxx/30
本文标题:mysql 字符串截取
本文链接:https://www.haomeiwen.com/subject/enmzeqtx.html
网友评论