On Wed, 11 Aug 2004 23:40:27 -0700, Scott Haneda <[EMAIL PROTECTED]> wrote: > > I made a mailing list archiver, I "thread" discussions by subject. I chose > to not use message-id's since so many people hijack threads.
Why not select/group on subject, and then thread on messageid. > Given this case: > > Subject ID > RE: Order by with one exception 1 > RE: Order by with one exception 2 > RE: Order by with one exception 3 > Order by with one exception 4 > RE: Order by with one exception 5 > RE: Order by with one exception 6 > RE: Order by with one exception 7 > > As you can see, these are in correct order, but in this case, I want to push > the one without the Re: to the top. I can not just order by subject, id, > since not a subject could start with a letter after "R". Suggestions? SELECT * FROM table ORDER BY subject NOT LIKE 're:%', ID Jochem -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]