Remove everything and including first slash: MySql
[code lang=”php”]UPDATE `song_copy` SET `song_path_new` = substring(`song_path_new`, instr(`song_path_new`, ‘/’) + 1)[/code] From: AAA/BBB/CCC TO: BBB/CCC
[code lang=”php”]UPDATE `song_copy` SET `song_path_new` = substring(`song_path_new`, instr(`song_path_new`, ‘/’) + 1)[/code] From: AAA/BBB/CCC TO: BBB/CCC