Update query for database

Question

What's wrong with my SQL update? I'm trying to update records with the upcoming value for status records with the value as missed & due_date BETWEEN 2020-08-01 AND 2020-12-31.

Where is the Syntax error?

UPDATE
  records
SET
  status = upcoming,
WHERE
  status = ‘ missed ’ & due_date BETWEEN 2020 -08 -01
  AND  2020 -12 -31 ;

score 1 · Accepted Answer · answered Jul 31 '20 at 01:50

I think this should be written as:

UPDATE records
   SET status = 'upcoming'
   WHERE status = 'missed' AND
         due_date BETWEEN '2020-08-01' AND  '2020-12-31';

Notes:

Strings should be in single quotes.
Dates should be in single quotes.
SQL uses AND not & for boolean AND.

Update query for database

1 Answers1