Go to
|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [MW].company_name) FROM [MW] Inner Join MW_A1 ON [MW].ID = MW_A1.Referral_ID WHERE (Category1 LIKE 'Beauty%' OR Category1 LIKE 'Hair%' OR Category1 LIKE 'Day Spa%' OR Category1 LIKE '%Organ%' OR Category1 LIKE '%Educat%' OR Category1 LIKE 'Grocery Store%' OR Category1 LIKE 'Specialty%' OR Category1 LIKE '%Delivery%' OR Category1 LIKE 'Greenmarkets%' OR Category1 LIKE 'Catering%' OR Category1 LIKE 'Wine, Beer%' OR Category1 LIKE 'Restaurants%' OR Category1 LIKE 'Wine Bar%' OR Category1 LIKE 'Coffee%' OR Category1 LIKE 'Juice%' OR Category1 LIKE 'Chocola%' OR Category1 LIKE 'Baker%' OR Category1 LIKE 'Clothing%' OR Category1 LIKE 'Gifts%' OR Category1 LIKE 'Office%' OR Category1 LIKE 'Pharma%' OR Category1 LIKE 'Florist%' OR Category1 LIKE 'Fabric%' OR Category1 LIKE 'Bed%' OR Category1 LIKE 'Furniture%' OR Category1 LIKE 'Nurser%' OR Category1 LIKE 'Recycling%' OR Category1 LIKE '%Waste%' OR Category1 LIKE 'Building%' OR Category1 LIKE 'Alternative%' OR Category1 LIKE 'Garden%' OR Category1 LIKE 'Arch%' OR Category1 LIKE 'Salvage%' OR Category1 LIKE 'Pet%' OR Category1 LIKE '%Cleaner%' OR Category1 LIKE 'Cleaning%' OR Category1 LIKE 'Pest%' OR Category1 LIKE 'Personal%' OR Category1 LIKE 'Burial%' OR Category1 LIKE 'Bank%' OR Category1 LIKE 'Real%' OR Category1 LIKE 'Telecom%' OR Category1 LIKE 'Utilit%' OR Category1 LIKE 'Carbon%' OR Category1 LIKE 'Public%' OR Category1 LIKE '%Taxi%' OR Category1 LIKE '%Bikes%' OR Category1 LIKE 'Car Rental%' OR Category1 LIKE 'Vehicle%' OR Category1 LIKE 'Fuel%' OR Category1 LIKE 'Travel%' OR Category1 LIKE 'Hotel%' )--0--Name-or-product--Name-or-product |
|
|
