I wanted to generate a random number (for a unique and unpredictable memberID) and insert it into every memberID column which has not a memberID already (equals NULL).
I dont want to change the already generated memberIDs in the meantime.
Code:
SELECT FLOOR(10000 + RAND() * 89999) AS random_number FROM customer WHERE "random_number" NOT IN (SELECT memberID FROM customer) LIMIT