Update table in wrong format

Question

update table set pontuacao='$var1' where id='1' AND diadojogo > '2017-09-28';
update table set pontuacao='$var1' where id='1' AND diadojogo >  2017-09-28 ;
update table set pontuacao='$var1' where id='1' AND diadojogo > '$data';

I know this syntax is wrong! I want to save the var1 on the field pontuacao of id=$x only if the $data is less than the figure in diadojogo, which is a sweep format '2017-09-28'.

Answer 1

update palpite set pontuacao='4' where (id='1' and diadojogo > '2017-09-26');