[Solved] Random Number in MySQL column [closed]

Try: UPDATE Table SET fieldName = ((rand() * 1000) % 40) + 10;

Because when you preset it in a variable, it’ll be the same for all…