esedic
9/2/2016 - 9:08 AM

Insert value if it doesn't already exist

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