Mysql lastindexof Function 만들기

CREATE FUNCTION `cloud`.`LAST_INDEXOF`(str VARCHAR(50), substr VARCHAR(50))
 RETURNS INT DETERMINISTIC
BEGIN

 RETURN LENGTH(str) - INSTR(REVERSE(str), substr) + 1;
END;