SEARCH result

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