Update a specified column in a a specified row

[Nick_Net2004]

Let say I got 3 row of data in my batabase

PRI FirstName LastName Position

1112 John Doe FR-45

1113 Mark Doe FR-45

1114 Dave Doe FR-45

 

I want to command to update the position of row 2 with PRI 1113 so that the position woul be no FR-45, but FR-02

 

How do I do that

P.S The PRI is a primary key, so unique, and I know its value

[wessamzeidan]

update yourtable set [position]=FR-02 where PRI=1113

 

use this sql statement to update your table