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%';