I am trying to figure out a way in SQL to match a comma separated field with another value.
select * from tbl_test where fld_search like '%Canton, Ohio, Biology , Chemistry%
In the database I have the word "Biology"
Now, the statement above doesn't work at all.
Any way to compare two fields ?