Group against Serialzed field - HOW TO?

[stryka]

Anyone know how to code logic to group against serialized field on a record?

I know that i would have to use the function unserialize() but do i create a result set and then group against that result?

[Marco van Herwaarden]

Serialized columns are not really to be used on MySQL manipulations.

[stryka]

umm... i understand that... but given the fact that i have serialized fields... how can i group a record based on this field...

[Marco van Herwaarden]

You can group like with any other column. But this will group together all the rows thqat have identical contents in this column. You can not group on parts of the content.