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 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 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
Archived
This topic is now archived and is closed to further replies.