List:General Discussion« Previous MessageNext Message »
From:Gerald Clark Date:July 25 2002 7:42pm
Subject:Re: Storing Records Alphabetically
View as plain text  
Use a separate field to hold the ignored words.

Mark Gowdy wrote:

>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.
>Before posting, please check:
>   (the manual)
>           (the list archive)
>To request this thread, e-mail <mysql-thread115546@stripped>
>To unsubscribe, e-mail
> <>
>Trouble unsubscribing? Try:

Storing Records AlphabeticallyMark Gowdy25 Jul
  • Re: Storing Records AlphabeticallyBenjamin Pflugmann25 Jul
  • Re: Storing Records AlphabeticallyGerald Clark25 Jul