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

2002-04-12 Thread Analysis Solutions
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

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

2002-04-12 Thread Julio Nobrega
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...