Search into an array of words

I need to define a column in the vendors DB with keywords so my users can find vendors by their needs.
For example a user might search:
“I need a new car”

And the results should be car vendors, to do so I have a Tag field in my vendors DB, with many keywords separated by comma “,”. For example:

Vendor1 [Tag] : car , truck , tires , brakes , speed , motor , fuel , etc…

Tag is not a list, it is just a txt field.

This is working with just the first 5 words, but when I add more words to the Tag field it doesn´t search for those words.

Maybe I am doing something stupid and there is a much better way to do this. Hope someone can help me find a better way that does not depend on the amount of words of the Tag field.

This topic was automatically closed after 70 days. New replies are no longer allowed.