>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 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, if a field called "data" contains serialized data that looks like this:

a:11:{s:7:"company";s:12:"Some Company";s:8:"jobtitle";s:17:"Assistant Manager";s:5:"phone";s:12:"123-456-7890";s:3:"fax";s:12:"987-654-3210";s:7:"bf_time";i:1135221050;s:8:"bf_value";d:2.416246843777560382449109965818934142589569091796875E-5;s:17:"signup_email_sent";i:1;s:6:"status";a:2:{i:2;i:0;i:1;i:1;}s:9:"is_active";i:1;s:9:"is_locked";s:0:"";s:11:"affiliation";s:1:"1";}

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)

Jenifer