Yeah that would work but the problem is that I will not know what the value of the (as in your case) "First". The field will be a number that changes frequently. I need to find some other way to update just the current record that I am working on.
Originally posted by kpalmer
You just need to add a WHERE clause to the end of your statement. If I was using a table of names with first and last names it would look something like this:
UPDATE Names SET First = "John", Last = "Smith" WHERE First = "John";
Depending on what type of field you are wanting to filter by you may have to alter the statement.