UPDATE users SET pin = CAST(CAST((RAND() * 10000) - 1 AS SIGNED) AS CHAR) WHERE email_addr NOT LIKE '%ausgrid.com.au';
UPDATE users SET pin = LPAD(pin, 4, '0') WHERE email_addr NOT LIKE '%ausgrid.com.au';
