how to edit a field in a table - newbie 2

[leegold]

Here's a newbie question, I did "google it" but couldn't sift out the answer.

I got a table with thousand records. There's one record that has one field whose value I want to edit. So basically I want to edit one field in my DB. I see the update command.... and each record has a unique PK of course so I have what I need to "zero-in" on the record - but not sure how. Thanks

 

[TonyGroves]

Try something like:
[tt]
UPDATE tablename
SET fieldname='asdf'
WHERE keyfieldname='1234'[/tt]


-----
ALTER world DROP injustice, ADD peace;

 

[KarveR]

UPDATE mytable set somefield='a_nice_value' where somefield='some_annoying_value';

additionally, use AND to add another field as a point of reference to ensure you get the ringht one:

UPDATE mytable set somefield='a_nice_value' where somefield='some_annoying_value' AND some_other_field='another_unique_value';

______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.