Dave Jarvis' Repositories

select * from recipe.ingredient_name where label ilike '%pepper%' order by label;

update recipe.ingredient_name set label='unsweetened hershey''s cocoa' where id=1476;

insert into recipe.ingredient_name (label) values ('extra lean ground beef');

insert into recipe.ingredient_name (label)
select label from recipe.ingredient_name_cache where valid=1;

select * from recipe.ingredient_locution_vw;

--delete from recipe.ingredient_name where id in (1261,1260,338,1432,1844,1838,1442,631);
--delete from recipe.ingredient_name_cache;