Insert into table if field value does not exists...

[RIRedinPA]

I'm trying to update an address book type database and what I want to do is add a record if the name field does not contain the name I am adding...

 

something like this:

 

INSERT INTO addressBook (id, name, title, phone, email) VALUES ('', 'skippy jones', 'redundant repeater', '555-555-1212', 'sjones@justanothercorporategiant.com') WHERE NOT EXISTS (SELECT * FROM addressBook WHERE name = 'skippy jones')

 

I get errors with this...

[ejaboneta]

I don't know if this is the best way, but I just make the field UNIQUE and it will not insert if it exists