mysql给数据库表里某个字段赋随机值

UPDATE sxz_goods set sales_volume_base = round(rand() * 50) + 1 where sales_volume_base =0 ORDER BY goods_id ASC