Very simple SQL Question REP+++

[arturhaddad]

I'm trying to randomize the levels of a certain account, I'm trying the following syntax:

UPDATE `players` SET `level` > 8 AND < 30 WHERE `account_id` = 4250183

But it keeps getting error

I want to put the levels in a value between 8 and 30, how can I do this?

I want to do this for a pvp event in my sv

Thanks!

REP+++
REP+++

 

[ruda]

try this

UPDATE `players` SET `level` = FLOOR(8 + (RAND() * 23)) WHERE `account_id` = 4250183;

 

[arturhaddad]

It worked. Nice job
Thanks!
REP'D++
By the way, could i ask why number 23? > (RAND() *23))

 

[ruda]

8 = min value
RAND() = float between 0 and 1 (1 not included)
23 = (max value + 1) - min value