How to make a search on the row in line?
Here is an example, you need to find on the field [STR] entry “A”:
 [n] "TABL", [STR] "A, B, C"  [n] "CATL", [STR] "B, C"
 [n] "TABL", [STR] "A, B, C"
Answer 1, Authority 100%
is not very clear the presentation of the table if
str are the columns of the table, then enough, as indicated in the comments, use the
select * From. TBL Whater STR LIKE '% A%'
 [N] "TABL", [STR] "A, B, C" and
 [n] "CATL", [STR] " B, C "These are the lines for which the search is carried out, it is better to use regular expressions, i.e. Operator
select * From. TBL Whater Name Rlike "\ [STR \]. * a. * $"
Answer 2, Authority 25%
Sorry, a person from comments helped, since he does not write that I will write.
select * from tbl where str like '% a%'