I need help with generating random string

[afaaro]

I have got this one but it's only working with small letters and numbers, how can i make both lower case and upper case and numbers as well. this is the query am using right now

dbquery("UPDATE ".CATEGORY." SET category_url=CONCAT(LOWER(SUBSTRING((CONV(SUBSTRING(RAND(), 3), 10, 36)), 1, ))");

Edited January 14, 2014 by afaaro

[Psycho]

I would suggest creating the code in PHP. But the below will work. It's ugly, but will work.

 

 

$query = "UPDATE " . CATEGORY . "
          SET category_url = CONCAT(
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1),
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1),
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1),
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1),
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1),
              SUBSTR('abcdefghijklmnopqrstuvwxyzABCDEFGHIJKLMNOPQRSTUVWXYZ0123456789', FLOOR(1+RAND()*62), 1)
          )";

[afaaro]

Woooow Thats amazing Psycho Thank you so much

Edited January 14, 2014 by afaaro