MySQL Double Equal Sign

Question

I'm debugging an old website, and I get some SQL errors. When I went through it, I found the following query.

UPDATE boats
set    new_high_date == DATE_ADD(NOW(), INTERVAL 3 MONTH)
WHERE  id=49701

I don't know what the == here means. Is this a valid query? I cannot seem to execute it.

I'm not sure if I should change this, or does it mean something?

Answer 1

There is no double equal in MySQL so you should remove it.

Answer 2

That is incorrect, there is no double equal sign in sql. The correct way to set is

UPDATE boats 
SET    new_high_date = DATE_ADD(NOW(), INTERVAL 3 MONTH)
WHERE  id = 49701