Re: Re: alphabetizing titles when first word begins with 'The','A',etc.

I would go with this. If there's a title like: "A title begins with a vowel". I guess it's better to store: "title begins with a vowel, A". Now how to transform.... INSERT-SELECT to a temp table where you will format, delete the original's records, and INSERT-SELECT from temp to original... -- Julio Nobrega. Tô chegando: http://www.inerciasensorial.com.br "Analysis & Solutions" <danielc@analysisandsolutions.com> wrote in message news:20020412145151.GB26123@panix.com... > > On Wed, 12 Apr 2000, Steph wrote: > > > > > Hi. Im using MySQL and as part of my tables I have titles (of stories). My > > > question os in regards to outputing those titles. Some of the titles begin > > > with words such as 'The', 'A', 'An', etc. Is there a > > > way to order these > > > particular titles based on the second word in the title?? > > Why not do what libraries do. Store the data correctly in the first > place? > > --Dan > > -- > PHP classes that make web design easier > SQL Solution | Layout Solution | Form Solution > sqlsolution.info | layoutsolution.info | formsolution.info > T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y > 4015 7 Av #4AJ, Brooklyn NY v: 718-854-0335 f: 718-854-0409