vynsane Posted March 28, 2007 Share Posted March 28, 2007 is there a good way to alphabetize results and ignore articles like "the", "and", "a", and "an" so that it will alphabetize by the next word? just wondering... Link to comment https://forums.phpfreaks.com/topic/44689-alphabetize-results-ignoring-and-and-the-and-such/ Share on other sites More sharing options...
vynsane Posted March 28, 2007 Author Share Posted March 28, 2007 never mind... i think i found something: ORDER BY TRIM( LEADING 'a ' FROM TRIM( LEADING 'an ' FROM TRIM( LEADING 'the ' FROM LOWER( column_name ) ) ) ) Link to comment https://forums.phpfreaks.com/topic/44689-alphabetize-results-ignoring-and-and-the-and-such/#findComment-217031 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.