mysql if contains_MYSQL IF字段包含这使得其他字段(MYSQL IF Field contains THIS make other Field THAT)...

I have a field called ITEM in my table1. If ITEM contains %USED-% (USED-) then I want to make its TIER1 Used Restaurant Equipment so it groups accordingly.

This is my current statement, how can I achieve the above with an IF or CASE?

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

Current Output:

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

I expect that there still be some NULL Tier1 and Tier2's but I want it to also display a TIER1 as 'Used Restaurant Equipment', similar to this:

TIER1 TIER2

NULL NULL

Used Restaurant Equipment NULL

Business Type Ice Cream Equipment

Chinese Food Equipment Ricers

Concession Equipment Concession