Dear Jason,
I have worked out the correct change I need to make to the SQL query but I am not sure how to add it to the Data Assist Search.
The current query is:
SELECT RecipeID, Title, Serves, Intro, WhatYouNeed, HereHow, CountAs, CatagoryID FROM Recipies WHERE FoodPlan = 1 AND ((Title LIKE '%milk%')) OR ((WhatYouNeed LIKE '%milk%')) LIMIT 0, 10
I need to change it to:
SELECT RecipeID, Title, Serves, Intro, WhatYouNeed, HereHow, CountAs, CatagoryID FROM Recipies WHERE HcgFoodPlan = 1 AND (((Title LIKE '%milk%')) OR ((WhatYouNeed LIKE '%milk%'))) LIMIT 0, 10
I just needed to add the additonal brackets around the query i.e (((Title LIKE '%milk%')) OR ((WhatYouNeed LIKE '%milk%'))). But I am not sure how to add this into the Data assist search assistant.
Many thanks as always for your help