给数据库某个表特定字段赋随机值

UPDATE ecs_goods set is_new = 0;

UPDATE ecs_goods set is_new = 1 ORDER BY RAND() LIMIT 3