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?