mysql 查找字符第二个_MySQL中的sql语句，怎么查询moto字段内容中第一个 . 和第二个 . 之间的字符有多少种，每种多少个？...

展开全部

给你做了个函数：create function funWWWlength(@var varchar(max))

returns int

as

begin

return

len(replace(replace(@var,left(@var,charindex('.',@var)),''),right(@var,charindex('.',@var)),''))

end

查询范例：declare @ttb table(moto varchar(max))

insert into @ttb

select '

select '

select 'web.aaaaa.com' union all

select 'web.bbb.com' union all

select 'web.ddddddddddasasasa.com'

select moto,dbo.funWWWlength(moto) as newmoto from @ttb

查询结62616964757a686964616fe58685e5aeb931333337376335果：

(5 行受影响)

moto                                                                                                                                                                                                                                                             newmoto

------------------------------------------------- -----------

www.a.com 1

www.b.com 1

web.aaaaa.com                                                                                                    5

web.bbb.com                                                                                                  3

web.ddddddddddasasasa.com                                                                     17

(5 行受影响)

后面就简单了：

declare @ttb table(moto varchar(max))

insert into @ttb

select 'www.a.com' union all

select 'www.b.com' union all

select 'web.aaaaa.com' union all

select 'web.bbb.com' union all

select 'web.ddddddddddasasasa.com'

select count( distinct dbo.funWWWlength(moto)) as newmoto from @ttb