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

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

>Best regards,
>  Olexandr Vynnychenko                          mailto:supaboy@stripped

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