MySQL Forums
Forum List  »  InnoDB

Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
Posted by: Phil Powell
Date: March 01, 2006 10:21AM

Roland Bouman wrote:
> Hi there,
>
>
>
> I don't know where your table_c comes into play -
> I'll ignore it. Post back if it is important.
>
> I put some extra data in order to have different
> values for the a_table - else it's no use: it's no
> fun sorting only one entry:
>
> mysql> insert into
> table_b(b_name)values('kungfu master');
> Query OK, 1 row affected (0.04 sec)
>

[snip]

I'm sorry but everything you did to this point completely lost me. I never could figure it out and wrote a PHP-based pseudo stored procedure to produce a Cartesian product and used PHP to manhandle the resultset back into shape, but what you described is too large for my brain to absorb, and I'm sorry.

Phil

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Sort (ORDER BY) by a comma-separated list of related fields using MySQL 4.1?
2652
March 01, 2006 10:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.