Selecting my data first

["Jake Conk" <jake.conk@xxxxxxxxx>]

Hello,

I have a table with 2 columns, file_id and owner_id. I want to select
all the files and order by file_id but I want the ones that belong to
me to show up first then everyone elses. Is this possible and how?

This is what I'm trying to accomplish:

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

I would suspect this can be accomplished by a sub query somehow but I
don't know how.

Thanks,
- Jake

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=royale@xxxxxxxxxx