I'm trying to run an \[code\]UPDATE\[/code\] and I'm getting a syntax error. I'm using php and PDO to create the \[code\]UPDATE\[/code\] command. What is wrong with my syntax?\[quote\] UPDATE education WHERE userId = :userId AND fieldId = :fieldId SET fieldId = :fieldId, educationTitle = :educationTitle, educationDegree = :educationDegree, startDate = :startDate, endDate = :endDate, educationDescription = :educationDescription;\[/quote\]Error:\[quote\] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE userId = '35' AND fieldId = '4' SET fieldId = '4', educationTitle = 'ththt' at line 1\[/quote\]UPDATE:I've tried placing \[code\]WHERE\[/code\] after \[code\]SET\[/code\] like the sample below, but I'm still getting a syntax error.\[quote\] UPDATE education SET fieldId = :fieldId, educationTitle = :educationTitle, educationDegree = :educationDegree, startDate = :startDate, endDate = :endDate, educationDescription = :educationDescription, WHERE userId = :userId AND fieldId = :fieldId;\[/quote\]