title: Take data from one table and store it into another
body: <p>I'm trying to write a trigger that will take any any daily_rate that is over 15 and put it into a new table known as valuable_item. I have already created the new table and so all I need is to carry over the required data. Below is the code I have tried within the trigger edit section:</p>
  
  <pre><code>INSERT INTO valuable_items (catalogue_id,
  description,
  designer,
  type,
  daily_rate)
  VALUES 
  (new.catalogue_id,
  new.description,
  new.designer,
  new.type,
  new.daily_rate, WHERE daily_rate &gt;= 15
  </code></pre>