It could be done with MySQL itself by either adding a sort_title field
that you make those changes to, by selecting the data into a temporary
table then performing the appropriate updates before selecting it
ordered properly, or by some crazy complex combinations of the if,
index, and substr funct
Steph,
> 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??
L
> 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 bas
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
4 matches
Mail list logo