SQL Query Possible?

[klassicd]

Hey everyone.

I have a column in one of my tables that carries information in this format:
0,1,0,0,1,0,1

Basically its just some personal information collected in a survey. What I need to do is select all users that have 1 for the 4th item in the value.

For example:
0,1,0,0,1,0,1

Is there anyone to do this in a query? I could do it in php but i would need to select row by row and check each value. Just wondering if mysql has something like select * from table where columnname[6]=1;

[astericks]

try using the substring feature for mysql

SELECT SUBSTRING('0,1,0,0,1,0,1',5,1);

it should work.

[klassicd]

Thanks works great.