Another form of UPDATE?

Question

I am doing a Mysql class work and would like to know another form of UPDATE, because this is not changing.

Update the price of service of all animals that received bath in the pet shop and had less than 15 real value.

---

UPDATE `aula_sub_query`.`servico_prestado` 
    SET `preco` = 25.00
    WHERE `cod_SERVICO_PRESTADO` = 1 AND `preco` < 25.00;

---

Answer 1

Andrews, assuming that the service code provided for Bath in the PET SHOP, is 1, as you are using in the WHERE, just correct the value of your condition.

Instead of using

UPDATE aula_sub_query.servico_prestado SET preco = 25.00
WHERE cod_SERVICO_PRESTADO = 1 AND preco < 25.00;

Utilize

UPDATE aula_sub_query.servico_prestado SET preco = 25.00
WHERE cod_SERVICO_PRESTADO = 1 AND preco < 15;