From: Peter Brawley
Date: January 20 2006 1:14am
Subject: Re: Selecting based on serialized field...
List-Archive: http://lists.mysql.com/mysql/194075
Message-Id: <43D03979.4030906@earthlink.net>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="=======AVGMAIL-43D039791E2F======="
--=======AVGMAIL-43D039791E2F=======
Content-Type: multipart/alternative; boundary=------------030803000508030702080901
--------------030803000508030702080901
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
/>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
>
>
--------------030803000508030702080901
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
>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
--------------030803000508030702080901--
--=======AVGMAIL-43D039791E2F=======
Content-Type: text/plain; x-avg=cert; charset=us-ascii
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
Content-Description: "AVG certification"
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.375 / Virus Database: 267.14.21/235 - Release Date: 1/19/2006
--=======AVGMAIL-43D039791E2F=======--