INSERT if not in the database?

Question

MySQL

In Google they say to do it through UNIQUE and they also offer this option

INSERT INTO table_listnames (name, address, tele)
VALUES ('Rupert', 'Somewhere', '022')
WHERE NOT EXISTS (
    SELECT name FROM table_listnames WHERE name='value'
);

But what's the best option?

Answer 1

There is no INSERT ... WHERE in MySQL.
So UNIQUE the index and INSERT IGNORE or INSERT ... ON DUPLICATE KEY UPDATE.