SQL %

There is a tableMyTable

One of the fieldsMyFieldThe format is: "'A', 'B', 'C '......, 'N '"

Is the number value separated by a string.

If I want to query allMyFieldThe field contains a 'A' record. How can this problem be found?

I tried:

Select * from myTable where 'A' in (myField)

Result error .... What should I do? For help.

Try find_in_set. I also used this record to find the desired record.

Solution:

Assume that the numbers are separated by commas (,) to query records containing number 2.
Select * from myTable where concat (',', myField, ',') like '%, 2, %'

If they are separated by other strings, replace the comma in single quotes with the string used.