Remove everyting after first / slash in mysql

[code lang=”php”]UPDATE my_table SET my_col = SUBSTRING_INDEX(my_col, ‘/’, 1)[/code]

From: AAA/BBB/CCC
To: AAA