Hi.
On Thu 2002-07-25 at 11:24:36 -0400, [EMAIL PROTECTED] wrote:
> Hi
>
> I am storing a list of titles on a mysql db. Some of the records start
> with 'The','A' or 'An'. I would like to be able to enter the title in
> the form 'The Count .....' instead of 'Count ..., The' and have the
> record stored as 'Count ....' but displayed as 'The Count ...' when I
> display it. Is there any easy way to do this when doing the INSERT or
> SELECT statements?
>
> Any ideas would be gratefully received.
IMHO, the usual solution to this is to have a seperate column
(e.g. "sort") for sorting, i.e. a column containing only "count ..."
which will be used in the ORDER BY clause:
SELECT title FROM whatever WHERE [...] ORDER BY sort
I do not think that there is an "easy" way, because there is no easy
way to know what is special (in my experience there is more than "A",
"An" and "The" to be considered).
Greetings,
Benjamin.
--
[EMAIL PROTECTED]
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
