rocknbil - 3:52 pm on Jun 1, 2012 (gmt 0)
Well, that is a poor database design because it robs you of the power of what mySQL can do. If you're going to store attributes associated with products, those attributes should be in joined tables, not in single strings you need to break apart with your programming.
For example . . . . [webmasterworld.com]
... and again [webmasterworld.com]
Given that, otherwise you'll have to devise some way of pulling all the fields, and in your programming breaking the data apart into arrays and sorting them by the digital element as a key. Really inefficient way to go about it.