calculating date in update mysql

Question

Good need to update my accounts that are past due more than 5 months, I wanted to do this directly in mysql. The update is like this:

UPDATE contas
SET baixa_valivade = true
WHERE data_vencimento (Preciso verificar se já esta vencida a mais de 5 meses)

Answer 1

Use the DATE_ADD():

UPDATE contas
SET baixa_valivade = true
WHERE data_vencimento BETWEEN DATE_ADD(CURRENT_DATE(), INTERVAL -5 MONTH) AND CURRENT_DATE()

---

If the need is to update items with delay date greater than 5 months, the code would be as follows:

UPDATE contas
SET baixa_valivade = true
WHERE data_vencimento < DATE_ADD(CURRENT_DATE(), INTERVAL -5 MONTH)