WHERE model = 'e71' OR model LIKE 'e71,%' OR model LIKE '%,e71' OR model LIKE '%,e71,%'

this is quite clumsy, yes?

better to use the FIELD() function

however, far better would be to normalize the data

StarLion
—
2012-07-09T14:26:44Z —
#7

r937 said:

this is quite clumsy, yes?

better to use the FIELD() function

however, far better would be to normalize the data

Field works with column names? I was trying to do it with a single query rather than pulling all results and then filtering in a separate one. Yes, it's very clumsy, which IS why the data should be normalized.