MySQL Database UPDATE LIKE Query error

Question

I am trying to update a row using query

 update tblstudent a, tmpstudent2013 b set a.dob=b.doa where a.dob like '%2013%' and a.admissionno=b.admissionid;

but it is giving me error: Incorrect datetime value "%2013" plz help

Answer 1

Try : where YEAR(a.dob) = 2013

Answer 2

Use YEAR()

update tblstudent a, tmpstudent2013 b 
set a.dob = b.doa 
where year(a.dob) = 2013
and a.admissionno = b.admissionid;