UPDATE query problem

I need to run an update in my database for all OwnerID=65

Here is what I am entering:

UPDATE OwnerID FROM 'Plots' SET value=0 WHERE OwnerID=65

It gives me this error: "You have an error in your SQL syntax near 'FROM 'Plots' SET value=0 WHERE OwnerID=65' at line 1"

What is it that I can't do legally here and how can I accomplish this otherwise?

UPDATE Plots SET value=0 WHERE OwnerID=65

I think he's referring to:

UPDATE Plots SET OwnerID=0 WHERE OwnerID=65

Originally posted by Lars Berg
UPDATE Plots SET value=0 WHERE OwnerID=65
[/B]

I did that and I get this error: Unknown column 'value' in 'field list'

So then I did this:

UPDATE Plots SET OwnerID value=0 WHERE OwnerID=65

and received the syntax error again (You have an error in your SQL syntax near 'value=0 WHERE OwnerID=65' at line 1)

Originally posted by Traduim
I think he's referring to:

UPDATE Plots SET OwnerID=0 WHERE OwnerID=65

Thank you so much! That was it! 😃