I have a column in my database that has values like this
Row1 : RA1,RA2
Row2 : XA1,XA2
I have a search form that will pass a value and query the
table.
If the user enters RA1 I need the search to return row 1, it
doesnt now
When I run the search query the result for row 1 is 'RA1,RA2'
so unless my user enters in RA1,RA2 no result is returned.
I need a result returned if the user enters any of the values
in the list not all of the values in the list.
How would I do this
... View more