MySQL replace functions cannot be solved using regular expressions

Update TTT set name = Replace (name, substring (name, locate ('Download/', name) + Length ('Download/'), 32), 'b8eb00508bf5e012e8762715035a6089 ')

 

1. First, locate ('Download/', name) finds the location where 'Download/' appears in name, and adds length ('Download/') as the second parameter of substring.

 

2. Because the string content is different but the format is fixed, the third parameter of substring is 32, that is, the length.

 

3. the truncated string is used as the second parameter of replace, that is, the value to be replaced. The third parameter is added with the value to be replaced, that is, 'b8eb00508bf5e012e8762715035a6089'

 

4. Try it, use it flexibly, and communicate with each other.