I have a column which will have values like:
FC FCW FC,FCW FX,FC
My input used for filtering should give correct result (match the exact value in the column) ex:
FC like 'FC,FCW' --> true FC like 'FCW' --> false
when I pass FC--> only 1st, 3rd and last record should be returned. (i.e, only FCW should not be matched)
Splitting the column using regexsplit and then checking the value is one way of doing. Since the table data is huge, this way takes lot of time. Is there any other simple way of doing this operation?