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
>
>
