SQL语句系列
模糊匹配修改部分
UPDATE CourseFiles
SET FilePath = REPLACE(FilePath, 'https://hls.lingyanspace.com/LimitVideo', 'https://dynamicapi.lingyanspace.com/AuthorizedFolderHost/LimitVideo')
WHERE FilePath LIKE '%https://hls.lingyanspace.com/LimitVideo%';
UPDATE CourseFiles
SET FilePath = REPLACE(FilePath, 'https://hls.lingyanspace.com/LimitVideo', 'https://dynamicapi.lingyanspace.com/AuthorizedFolderHost/LimitVideo')
WHERE FilePath LIKE '%https://hls.lingyanspace.com/LimitVideo%';