|
You can increase search results by using partial words (ie. 'orga% cott%' for 'organic cotton') SELECT COUNT(DISTINCT [CY].company_name) FROM [CY] Inner Join CY_A1 ON [CY].ID = CY_A1.Referral_ID INNER JOIN User_Input ON [CY].Company_Name = User_Input.Company_Name WHERE (Category1 LIKE 'Beauty%' OR Category2 LIKE 'Beauty%' OR Category3 LIKE 'Beauty%' OR Category4 LIKE 'Beauty%' OR Category1 LIKE 'Hair%' OR Category2 LIKE 'Hair%' OR Category3 LIKE 'Hair%' OR Category4 LIKE 'Hair%' OR Category1 LIKE 'Yoga%' OR Category2 LIKE 'Yoga%' OR Category3 LIKE 'Yoga%' OR Category4 LIKE 'Yoga%' OR Category1 LIKE 'Pharma%' OR Category2 LIKE 'Pharma%' OR Category3 LIKE 'Pharma%' OR Category4 LIKE 'Pharma%' OR Category1 LIKE 'Day Spa%' OR Category2 LIKE 'Day Spa%' OR Category3 LIKE 'Day Spa%' OR Category4 LIKE 'Day Spa%') AND DNQ = 0 --0--Name-or-product--Name-or-product |
|
Browse Ratings |
|
|
|||||||
