List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:May 30 2001 8:27pm
Subject:Re: Strange ORDER results
View as plain text  
At 10:32 PM +0300 5/30/01, Olexandr Vynnychenko wrote:
>Hello everyone,
>
>I tried 2 queries:
>
>1) SELECT id, CONCAT(title, ' [', id, ']') as name FROM rubrics ORDER BY name
>2) SELECT id, CONCAT(title, ' [', id, ']') FROM rubrics ORDER BY title, id
>
>The 2nd returns results in alphabetical order but the 1st is a little
>bit strange... Does anybody knows why they return results in different
>order?

This would not be unusual if id is a numeric column.

>
>database,sql,query
>
>--
>Best regards,
>  Olexandr Vynnychenko                          mailto:supaboy@stripped


-- 
Paul DuBois, paul@stripped
Thread
Strange ORDER resultsOlexandr Vynnychenko30 May
  • Re: Strange ORDER resultsPaul DuBois30 May