almightyegg Posted February 25, 2010 Share Posted February 25, 2010 I am trying to generate an alphabetical list of albums as such The Bachelor Best of Supertramp Dark side of the moon etc... As you can see, The Bachelor is first because I want it to remove the "The" so it alphabetises it by "Bachelor" So my question is how would I alphabetise it in a ORDER BY clause within a mysql_query() At I guess some sort of explode or implode but I don't know how I'd check if it has "The" at the beginning Thanks for help Quote Link to comment https://forums.phpfreaks.com/topic/193346-alphabetising-removing-the-from-the-beginning-of-results/ Share on other sites More sharing options...
PFMaBiSmAd Posted February 25, 2010 Share Posted February 25, 2010 http://www.arraystudio.com/as-workshop/how-to-sort-mysql-results-ignoring-definite-and-indefinite-articles-the-a-an.html Quote Link to comment https://forums.phpfreaks.com/topic/193346-alphabetising-removing-the-from-the-beginning-of-results/#findComment-1018027 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.