SQL模糊查找替换

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/原来的字符串