- UPDATE your_table
- SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
- WHERE your_field LIKE '%articles/updates/%'
转载请注明:谷谷点程序 » mysql替换字符串
- UPDATE your_table
- SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
- WHERE your_field LIKE '%articles/updates/%'
转载请注明:谷谷点程序 » mysql替换字符串