On 6/21/07, CA Lists <[EMAIL PROTECTED]> wrote:
Note that "uid" 12880 is now AFTER 12878, which is its parent.
Sounds like you want ORDER BY COALESCE(parent, uid) DESC.
- Perrin
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql
Does anyone have a clever way that I can sort on two fields? Let me
explain...I need the sort to be by the "uid" field (see below), but also
have the "parent" field taken into consideration:
Here's a sample of what I get now:
+---+---++
| uid | duplicate | parent |
+---+
carreraSC wrote:
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
No one has any ideas?
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
I
Hi,
I've got a sorting question that I can't figure out. The page in
question is here:
http://toolstudios.com/intera/careers/index.php
I'd like it to show up like this:
Accounting
job 1
job 2
Engineer
job 1
job 2
IT
job 1
job 2
3 separate columns. You woudl save space (not decimal points to
specify, and the nubmers would be stored as numbers) and sorting it the way
you want would be much easier and faster.
Chris
-Original Message-
From: Agrin, Nathan [mailto:[EMAIL PROTECTED]
Sent: Friday, November 14, 2003 10
I've seen this question posted in various forms on the web, but not in
such a way that I have found helpful. I have a column of data in the
following format name.xx.yy where the x's and y's represent numbers.
When selected by mySQL, the column is sorted in an odd way, given by the
following exampl
Hi,
I have a database with 5 teams and each team has 'n' categories and each
category has 5 sub-categories.
i.e TeamOne = Ottawa, Category 1 = Player Name, Sub-Categories = Goals,
assists, ppg, gwg, points.
Team0ne
Category 1
Sub 1
Sub 2
* Cindy
> OK, I determined that at least part of the problem was that I ran out
> of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in
> size an am trying again. But I'd still be very interested in any
> comments on the below select statement given the size of everything
> involve
OK, I determined that at least part of the problem was that I ran out
of space in /var/tmp, so I reset TMPDIR to a directory that's 40G in
size an am trying again. But I'd still be very interested in any
comments on the below select statement given the size of everything
involved (eg, an 1800M f
I wrote earlier:
>select b.id, a.aid, a.wid, a.start, a.length
>into outfile 'newindex.txt'
>from wordindex a, wordforms b
>where a.wordform = b.wordform
>order by b.id, a.id, a.wid, a.start;
I've actually sat down and tried this at the mysql command line.
P
OK< I must say I don't think much of this filter if it couldn't tell
it was a relevant question. After all, there's a select statement in
it!! Anyway, any help or comments appreciated. Since initially
sending this, I've learned why my predecesser did it this way -- eight
hours later, and it's
hi,
i have to sort a list of alpha-numeric data,
this is what the list should look like when i give an order command:
123a
123b
123c
123A
123B
123C
but this is the result:
123a
123A
123b
123B
123C some fields he puts the capital letters first
123c
How can i become the list above, i'v
13 matches
Mail list logo
