title: How to reduce the query count
body: <p>I am trying to produce a <code>catalog</code> table, so that every time I add to 2 other tables it will be the same <code>id</code>. Currently, I have to run the multiple query to produce. Just want to try and simplify it. This is my raw query any consolidation ideas are appreciated!</p>
  
  <pre><code>update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = '32g bins')
  where item_name = '32g bins';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Collection Bags')
  where item_name = 'Collection Bags';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Chicken Wire Bins')
  where item_name = 'Chicken Wire Bins';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = '5 gallon buckets')
  where item_name = '5 gallon buckets';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Spray Paint')
  where item_name = 'Spray Paint';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Open Sign')
  where item_name = 'Open Sign';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Pricing Sign')
  where item_name = 'Pricing Sign';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Calrecycle Sign')
  where item_name = 'Calrecycle Sign';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Water Dispenser')
  where item_name = 'Water Dispenser';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Water Bottles')
  where item_name = 'Water Bottles';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Safe')
  where item_name = 'Safe';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Security System')
  where item_name = 'Security System';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Hand Sanitizer')
  where item_name = 'Hand Sanitizer';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Working Gloves')
  where item_name = 'Working Gloves';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Cleaning Gloves')
  where item_name = 'Cleaning Gloves';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Ear Plugs')
  where item_name = 'Ear Plugs';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Safety Goggles')
  where item_name = 'Safety Goggles';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Office Desk')
  where item_name = 'Office Desk';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Change/Cash Deposit Bags')
  where item_name = 'Change/Cash Deposit Bags';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Laptop')
  where item_name = 'Laptop';
  
  update equipment_needed
  set  `catalog_id` = (select `id` from equipment_catalog where item_name = 'Writing Pens')
  where item_name = 'Writing Pens'
  
  ;
  </code></pre>