Unfortunately, I'm on 4.0.x so sub-queries are out. And yeah, I
should get my host to upgrade.... but we both work for the government
so that isn't happening. ;-)
Any other thoughts.
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
On Dec 21, 2006, at 9:30 AM, Naintara wrote:
Depending on your MySQL version you could use a subquery by
combining the
two queries you mentioned, for a fairly straight-forward query.
http://dev.mysql.com/tech-resources/articles/4.1/subqueries.html
http://mysqld.active-venture.com/Subqueries.html
You could read about optimizing subqueries for optimum queries.
-----Original Message-----
From: Kevin Murphy [mailto:php@xxxxxxxxxxxxxxxxxx]
Sent: Thursday, December 21, 2006 10:49 PM
To: php-db@xxxxxxxxxxxxx
Subject: Order By [blank]
I have this column in mysql:
A
F
D
[ empty ]
A
C
If I do an order by on that column, this is what I get:
[ empty ]
A
A
C
D
F
What I would like is this:
A
A
C
D
F
[ empty ]
Is there any way to achieve this in a single MySQL query? Using
DESC in this
case doesn't work, because while it puts the empty row in the last
place, it
does the rest as well. I could also do 2 queries where it calls it
once in
order WHERE !='', and then do another query to get the empty ones,
but that
seems a bit cumbersome.
--
Kevin Murphy
Webmaster: Information and Marketing Services Western Nevada Community
College www.wncc.edu
775-445-3326
--
Kevin Murphy
Webmaster: Information and Marketing Services
Western Nevada Community College
www.wncc.edu
775-445-3326
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
