simple SQL statement or so I thought but I am am being blocked by an error.

Any comment?

Error message

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE sso IS NOT NULL' at line 3

SQL statement

INSERT INTO tbl_staff( interface, interface_iso )
VALUES ( 1111111111111111, 11111 )
WHERE sso IS NOT NULL

Select statement that works

SELECT `sso` , `interface` , `interface_iso`
FROM `tbl_staff`
WHERE sso IS NOT NULL

You cannot use WHERE clauses in an INSERT query.

so if I have several records that need to be updated, how would one go about just updating the specific records based on a given condition?

Well, that would need an UPDATE query NOT an INSERT

ahhhh, thank you.