Dave Jarvis' Repositories

recipe-fiddle / database / scripts / ingredient-name-synonym_upsert.sql

insert into ingredient_name_synonym (ingredient_name_id, label) values (
  (select id from ingredient_name where label = 'schnitz un knepp'),
  'schnitz un gnepp'
);