Searching using comma separated list
I am trying to achieve a search like this.
My data has a field which contains a comma separated list of keywords. The visitor can enter a list of comma separated keywords. I want to return results where the data contains any of the words entered in the search.
I can see it's straight forward for the results to contain any keywords but not if a field contains a separated list.
My thinking is I explode the field into an array but I'm not sure how Data Bridge Search can handle that.
Your advice would be very much appreciated.