Cacher is the code snippet organizer for pro developers

UPDATE tb_guarachat_registro
SET ganadores = '0'
WHERE ganadores is null

// If you want to delete all those rows containing username = NULL
// then
DELETE FROM table_name WHERE username IS NULL;
// and for removing all those rows in select statement
SELECT * FROM table_name WHERE username IS NOT NULL;