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" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > > 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
