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