title: MYSQL IF Field contains THIS make other Field THAT
body: <p>I have a field called <code>ITEM</code> in my table1.  If <code>ITEM</code> contains <code>%USED-%</code> (USED-) then I want to make its <code>TIER1</code> <strong><code>Used Restaurant Equipment</code></strong> so it groups accordingly.</p>
  
  <p>This is my current statement, how can I achieve the above with an <code>IF</code> or <code>CASE</code>?</p>
  
  <pre><code>select 
      CT.TIER1, CT.TIER2
  from
      trx.table1 MT
          LEFT JOIN
      trx.table2 CT1 ON MT.ITEM = CT1.ITEM
          LEFT JOIN
      trx.table3 CT ON CT1.WEB_NUM = CT.WEBNUMBER
  GROUP BY CT.TIER1
  LIMIT 0 , 15
  </code></pre>
  
  <p>Current Output:</p>
  
  <pre><code>TIER1                   TIER2
  NULL                    NULL
  Business Type           Ice Cream Equipment
  Chinese Food Equipment  Ricers
  Concession Equipment    Concession Accessories
  Cooking Equipment       Fryers
  Food Preparation        Food Preparation Supplies
  Food Storage            Storage Racks
  Food Warming Equipment  Hot Food Wells
  </code></pre>
  
  <p>I expect that there still be some <code>NULL</code> Tier1 and Tier2's but I want it to also display a TIER1 as 'Used Restaurant Equipment', similar to this:</p>
  
  <pre><code>TIER1                      TIER2
  NULL                       NULL
  Used Restaurant Equipment  NULL
  Business Type              Ice Cream Equipment
  Chinese Food Equipment     Ricers
  Concession Equipment       Concession 
  </code></pre>