一个SQL

Question

select left(replace(字段,'http://',''),CHARINDEX('/',replace(字段,'http://','')))
from table

Answer 1

select repalce(字段，"http", "") from table

Answer 2

select replace(left(字段,CHARINDEX('/',字段) - 1 ),'http://','')
from from table

Answer 3

select left(replace(字段,'http://',''),CHARINDEX('/',replace(字段,'http://',''))-1) from [table]

Answer 4

select left(replace(字段,'http://',''),CHARINDEX('/',replace(字段,'http://','')) - 1)
from table
可以
select replace(left(字段,CHARINDEX('/',字段) - 1 ),'http://','')
from from table不行

Answer 5

select left(replace(字段,'http://',''),charindex('/',replace(字段,'http://',''))-1) from 你的表或select left(aa,charindex('/',aa)-1) from
(select replace(字段,'http://','') as aa from 你的表) a