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:

>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.
>
>Thanks
>
>Mark
>
>---------------------------------------------------------------------
>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 <mysql-thread115546@stripped>
>To unsubscribe, e-mail
> <mysql-unsubscribe-gerald_clark=suppliersystems.com@stripped>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


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