I have a recipe database. 2 fields (Recipe Name and Ingredients). I want to query Recipe Name using 2 words and also query Ingredients. Example: asian salad in Recipe Name and lettuce in Ingredient. Using the formula below it works well using one word but how to search using 2 words?
SELECT *
FROM “Recipe Table”
WHERE “Recipe Name” LIKE ‘%’ || :Enter_Search_Word || ‘%’
AND “Ingredients” LIKE ‘%’ || :Enter_Search_Word || ‘%’
If you are looking for the two words to be together in the recipe name, such as ‘asian salad’, there is nothing to do. Just enter in the first parameter prompt. If looking for ‘asian’ and ‘salad’ to be individually anywhere in the recipe name then just add another item in the WHERE statement:
SELECT * FROM "Recipe Table" WHERE "Recipe Name" LIKE '%' || :Enter_Recipe_Word_A || '%' AND
"Recipe Name" LIKE '%' || :Enter_Recipe_Word_B || '%' AND "Ingredients" LIKE '%' || :Enter_Ingredients_Word || '%'Thanks for getting back to me. I tried that and it only asked " :Enter_Search_Word" once
Sorry. Only based it upon your original post and thought you knew how parameters worked. Each :Enter_Search_Word will use the same input wherever used. To have three different input parameters they each need to be spelled differently such as :Enter_Recipe_Word_A, :Enter_Recipe_Word_B, :Enter_Ingredients_Word.
Thanks Ratslinger. I am new to SQL and love it. Just have to learn the lingo, etc. Help like you make it easier.
If this answers your question please click on the 
(upper left area of answer).