MySQL Lists: mysql: Re: Selecting my data first

List:	General Discussion	« Previous Message Next Message »
From:	Omni Adams	Date:	May 12 2008 6:56pm
Subject:	Re: Selecting my data first
View as plain text

On Mon, May 12, 2008 at 11:36 AM, Jake Conk <jake.conk@stripped> wrote:

>
> SELECT * FROM whiles WHERE owner_id=<my_id> first THEN SELECT * FROM
> files ORDER by file_id
>

Would this work?

SELECT *
FROM whiles
WHERE owner_id = <my_id>
ORDER BY owner_id = <my_id> DESC, file_id

Thread
• Selecting my data first	Jake Conk	12 May
• Re: Selecting my data first	Philip M. Gollucci	12 May
• Re: Selecting my data first	Jason Pruim	12 May
• Re: Selecting my data first	Omni Adams	12 May
• Re: Selecting my data first	Andy Wallace	12 May