Insert value if it doesn't already exist
INSERT INTO `manufacturers` (value) SELECT 'Audi' FROM `manufacturers` WHERE NOT EXISTS (SELECT * FROM `manufacturers` WHERE value='Audi') LIMIT 1