The problem with "the"

Written by on

A while back, I was working with a list of companies being displayed on a client's site, and I ran into an obvious issue. Some businesses' names begin with the word "the". Their names are in the MySQL database with the word "the" already in the business name column. I need to sort the business names alphabetically, but I don't want the "Ts" to be populated with all the "the's". Those businesses need to be sorted by the first letter after the "the". I have read that some people like to actually insert the word "the" into a separate column, then sort by the business name and then rebuild the two columns after the fact. These amount of steps seem to be a bit cumbersome, as one would need to check the name upon insertion and split the name if "the" exists, then always build the name again after sorting in the "select" statement.

Real Time Web Analytics ^