try ORDER BY `title`, `year`
and/or specify the direction like ORDER BY `title` ASC, `year` DESC yarr! pirate_lenny wrote: > > > I've got a title column and a year column. I'd like to be able to sort > it so that all of the same titles are together and then sorted > chronologically. > > How do I do this? > > Here's what I have: > > SELECT .... > ORDER BY title AND year > > But, that gives me an unsorted list. How do I fix? > > [Non-text portions of this message have been removed]
