Strange ORDER results

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

Re: Strange ORDER results

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