34,590
社区成员
发帖
与我相关
我的任务
分享
where len(col)-len(replace(col,'.',''))=1
where name like '%[0-9]%'
where patindex('%[0-9]%',name)>0
select * from
(
select '123.221.125.361' as ip
union all
select '192.168.1.1'
union all
select '192.168.1.abc'
union all
select '192.168.1'
) t
where len(ip)-len(replace(ip,'.',''))=3 and isnumeric(replace(ip,'.',''))=1
and len(ip) between 7 and 15
select * from
(
select '123.221.125.361' as ip
union all
select '192.168.1.1'
union all
select '192.168.1.abc'
union all
select '192.168.1'
) t
where len(ip)-len(replace(ip,'.',''))=3 and isnumeric(replace(ip,'.',''))=1