CREATE FUNCTION uniqueFlag(flags TEXT) RETURNS TEXT BEGIN DECLARE output TEXT; DECLARE i INT DEFAULT 0; DECLARE len INT DEFAULT 0; DECLARE temp VARCHAR(1); SET len = LENGTH(flags); compareLoop:LOOP SET temp = SUBSTRING(flags FROM i FOR 1); SET output = IF(output NOT LIKE CONCAT('%', temp, '%'), CONCAT(output, temp), output); SET i = i + 1; IF i < len THEN ITERATE compareLoop; END IF; LEAVE compareLoop; END LOOP; RETURN output; END