Re: Selecting my data first

["Philip M. Gollucci" <pgollucci@xxxxxxxxxx>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Jake Conk wrote:
| 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

select * from files where owner_id = you
union
(select * from files where owner_id != you order by file_id)


- --
- ------------------------------------------------------------------------
Philip M. Gollucci (philip@xxxxxxxxxxxxxx)
o:703.549.2050x206
Senior System Admin - Riderway, Inc.
http://riderway.com / http://ridecharge.com
1024D/DB9B8C1C B90B FBC3 A3A1 C71A 8E70  3F8C 75B8 8FFB DB9B 8C1C

Work like you don't need the money,
love like you'll never get hurt,
and dance like nobody's watching.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v2.0.8 (FreeBSD)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFIKI81dbiP+9ubjBwRAuOiAJ9e4kGv1qIUs7CbF5LGv30CaQfZgACdHXFM
FKFSw66nKpVqcJDug776TBI=
=YQxy
-----END PGP SIGNATURE-----

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