sql query:using insert and where query together

Question

i have a table like this:

name code group

john 12
smith 15

how do i insert group for a specified row??

say for 'smith' i have to insert the group.. i tried d following:

INSERT INTO table (group) VALUES ('usher') where code =15

error: Incorrect syntax near the keyword 'where'.

please help!!

thanx in anicipation!!

Answer 1

UPDATE  mytable
SET     group = 'usher'
WHERE   code = 15

Answer 2

As mentioned in the previous answer you want to perform an UPDATE not an INSERT.

UPDATE is used to change existing rows while INSERT will create new rows. Hence why WHERE can not be used with an INSERT statement.