Is there a way to make a restriction on a list that instead of looking for an exact match, restricts by any of the criteria words?
For example: I need to find a spare for a repair of a spare parts list in stock, but only show spare parts for that brand and model. The list may not be loaded exactly as in the repair.
If the repair was a Motorola G5 + XT1680 cell phone, the list might contain brand: Motorola, model: G5 +, or model: XT1680.
If restrictions could be made for all the words in the text, a list could be obtained with all the G5 +, plus all the XT1680.
Is it possible to make a restriction like this?
Reading about the SELECT expression, it does not seem possible to use several restriction criteria.
Thank you for your contribution