All pastes #734861 Raw Edit

ww

public sql v1 · immutable
·published 2007-10-13 02:33 UTC
rendered paste body
CREATE FUNCTION uniqueFlag(flags TEXT) RETURNS TEXTBEGIN	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