Sorting Question

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 |

Re: Sorting Question

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:

Weird Sorting Question. REPOST (Modified by carreraSC)

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 job 1

Re: Weird Sorting Question. REPOST (Modified by carreraSC)

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 job 1 job 2

Weird Sorting Question.

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 Basically, I'd

Sorting question

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

RE: Sorting question

(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:44 AM To: [EMAIL PROTECTED] Subject: Sorting

Sorting question

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

Re: (fwd) sorting question

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

Re: (fwd) sorting question

* 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 involved

(fwd) sorting question

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

Re: (fwd) sorting question

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.

sorting question

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,