DELIMITER $$

USE `abrs_new`$$

DROP FUNCTION IF EXISTS `seat_count`$$;

CREATE  FUNCTION `seat_count`(seatno VARCHAR(250))
 RETURNS VARCHAR(250)
 BEGIN
	SET @str= REPLACE(seatno, ',', '')
	SET @stcnt=CHAR_LENGTH(str);
	SET @x=1;
	SET @result;
	WHILE (@x <= @stcnt)
	DO
		SET @st=SUBSTRING_INDEX(@str,',',X);
		IF ((LENGTH(@seatno) - LENGTH(REPLACE(@seatno, st, '')))/LENGTH(@st)=1)
			THEN SET @result=CONCAT(@st,@result);
			ELSE IF ((LENGTH(@result) - LENGTH(REPLACE(@result, @st, '')))/LENGTH(@st) >0)
				THEN SET @result=CONCAT(@st,@result);

		 END IF;
		 SET @x=@x+1;
	END WHILE;
	RETURN @result;
END

DELIMITER ;