Re: Selecting based on serialized field...

2006-01-20 Thread SGreen
"Subscriptions" <[EMAIL PROTECTED]> wrote on 01/19/2006 06:13:06 PM: > I'm not sure if this falls under a PHP topic or a MySQL topic, but I have a > table that contains a field that stores serialized data. Is there a way to > order a recordset by a piece of the serialized data? For example,

Re: Selecting based on serialized field...

2006-01-19 Thread Peter Brawley
>is there a way to select a recordset ordered by "company"?  Kind of like, >but not quite:  SELECT * FROM mytable ORDER BY companyname >(where the "companyname" is some function that pulls out the company name) Yes you can ORDER BY a function result. PB - Subscriptions wrote: I'm n