Hi, my DB has values such as “black pants” and “black track pants”. When some searches for black pants I want the result to be black pants only and not black track pants in the result. So DB entries look like “Brand small black pants” and/or “XXL black track pants” and similar variations.
Can someone suggest a way to accomplish this? I am using contains keyword(s) in the constraint.