Complicated condition

Question

I have predefined item combination (for example brand1|brand2|brand3 etc) in the table. i like to collect brands and check against with predefined table data. For example i collected brand1|brand2|brand3 then i can do get some value form that predefined table(it meets the condition). How can i check? brands would be unlimited. also brand1|brand2|brand3 of brand1|brand2| exist then returns true.

Answer 1

Okay, taking a wild guess at what you're asking, you have a delimited field with brands in them separated by a | character. You want to return any row that has the right combination of the brands in there, but don't want to return rows with, for example, brand "testify" in them when you search for "test".

You have four search conditions (looking for brand3):

1. the brand exists by itself: "brand3"
2. the brand starts the delimited field: "brand3|brand4|brand6"
3. the brand is in the middle of the field: "brand1|brand3|brand6"
4. the brand is at the end of the field: "brand1|brand2|brand3"

so, in SQL:

SELECT *
FROM MyTable
WHERE BrandField = 'brand3'
   OR BrandField LIKE 'brand3|%'
   OR BrandField LIKE '%|brand3|%'
   OR BrandField LIKE '%|brand3'

Repeat as required for multiple brands.