Change from Postgre to MySQL query error

[Quang Nguyen]

Hi there,

I tried to switch my application from postgres to mysql. The problem is i don't know how to change below sql query to mysql.

UPDATE datavalue as d1 SET value=d2.value,storedby=d2.storedby,lastupdated=d2.lastupdated,comment=d2.comment,followup=d2.followup FROM datavalue AS d2 WHERE d1.periodid=d2.periodid AND d1.sourceid=d2.sourceid AND d1.lastupdated<d2.lastupdated AND d1.dataelementid=1 AND d1.categoryoptioncomboid=2 AND d2.dataelementid=3 AND d2.categoryoptioncomboid=4;

I was wondering if you guys can help me out.
Thank you very much!
Best regards,
Quang