SELECT TOP 10000 [id]
,[a]
,[b]
,[c]
,[d]
,[e],
replace([e],'href=www.test.com/','href=') aaa
,[f]
,[g]
,[h]
,[i]
,[j]
,[k]
,[l]
,[m]
from test_table
where --e like '%href=www.test.com/%'
m='system' and create_time>'20220513' and create_time<'20220514'
替换:
update test
set url = replace(url, 'www.test.com', 'www.test.com/abc')
where id = 1;
最终的:www.test.com/abc/原来的字符串