Remove last char if it's a specific character

Question

I need to update values in a table by removing their last char if they ends with a +

Example: John+Doe and John+Doe+ should both become John+Doe.

What's the best way to achieve this?

Answer 1

UPDATE table 
SET field = SUBSTRING(field, 1, CHAR_LENGTH(field) - 1) 
WHERE field LIKE '%+'