"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,
>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
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:1
