Bulk mysql query?

Question

MySQL

Good afternoon, tell me please. There is a request

$this->db->query('UPDATE `s_variants` SET `stock` = REPLACE(`stock`, "99999", "0");');

It can be seen that in the s_variants table in the stock column , 99999 is replaced by 0

Answer 1

UPDATE s_variants SET price/stock = 0
will set the price/stock field value to 0 in all records.
Instead of price/stock, leave the desired column