How do I make a MySQL insert query that "inserts if not exists"?

Question

INSERT INTO table('name') VALUES("abc") IF NOT EXISTS name='abc'

If abc doesn't exist in the name column, then insert it. How can I write that query?

Answer 1

INSERT IGNORE INTO table(name) VALUES('abc')

This will ignore the value if it already exists. Like pjotr said, this will require name to be a unique index. Source