Hi murali,

I got it thru stored function... here it's .. but what i m looking is that built-in function for this.. We hope that this utility may be available in future mysql releases.


/* *************************************************
Purpose : To get the random string (only alphabets)
Input : Length of the randon string required (pmStringlength)
************************************************** */
CREATE FUNCTION get_random_string(pmStringlength INTEGER) RETURNS VARCHAR(100)
DETERMINISTIC
BEGIN
DECLARE vString_length INTEGER;
DECLARE vReturn_string VARCHAR(100) DEFAULT '';
DECLARE vTemp1 INTEGER;
DECLARE EXIT HANDLER FOR SQLEXCEPTION BEGIN RETURN -99; END;

SET vString_length = pmStringlength;

-- Loop will execute to the no of characters given in input
WHILE vString_length > 0 DO
-- Getting a random number between 65 and 122
SET vTemp1 = FLOOR( 65 + (RAND() * 57));
IF (vTemp1 >= 90 AND vTemp1 <= 96) THEN
SET vTemp1 = vTemp1 + 10;
END IF;
-- Changing the random number into character and concatenate
SET vReturn_string = CONCAT(vReturn_string,CHAR(vTemp1));
SET vString_length = vString_length - 1;
END WHILE;
-- Return result
RETURN vReturn_string;
END;

/**************************************/

SELECT get_random_string(10);
Result : eOrcWKhxko

SELECT get_random_string(105)
Result : qSDTgeqspfwToBkcoNmIdmbjyQhgqNegiJPoRDUfLCakCypJTK uCeKiHEwbCdEDGUdJhCgPSmuPdSibmLdfcirivjASeKydOtmKa

__________________
Keep smiling...