I have a column in one of my tables that carries information in this format:
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.
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=1;