Remove everyting before last / slash in mysql

[code lang=”php”]UPDATE `table` SET `column` = SUBSTRING_INDEX(`column`,’/’,-1);[/code]

From: AAA/BBB/CCC
To: CCC