kristen Posted March 19, 2010 Share Posted March 19, 2010 Hi, I have googled extensively on this subject and just cannot find the answer, but it seems like it MUST exist! I have a list of articles in my database. I want to sort them alphabetically. "Okay," you say, "so pop in 'ORDER BY name' and you're good to go." Except that a few article titles are like in quotation marks, like "I Can't Take it Anymore!" - so these show up at the top of the list. I want to run the query, escaping symbols so that the articles show up properly in the list, instead of those that begin with symbols staying at the top. Does anyone know how to do this? Thanks! Link to comment https://forums.phpfreaks.com/topic/195827-mysql-order-by-alphabetical-but-exclude-symbols/ Share on other sites More sharing options...
trq Posted March 20, 2010 Share Posted March 20, 2010 No function like that exists. You would need to strip those special chars out of your results and re-order them. Link to comment https://forums.phpfreaks.com/topic/195827-mysql-order-by-alphabetical-but-exclude-symbols/#findComment-1028919 Share on other sites More sharing options...
kristen Posted March 22, 2010 Author Share Posted March 22, 2010 Could you please elaborate on this? I am drawing a blank on how I would re-order after stripping those characters. Thanks! Link to comment https://forums.phpfreaks.com/topic/195827-mysql-order-by-alphabetical-but-exclude-symbols/#findComment-1030149 Share on other sites More sharing options...
kristen Posted April 20, 2010 Author Share Posted April 20, 2010 Bumping this, hoping someone can help... thanks! Link to comment https://forums.phpfreaks.com/topic/195827-mysql-order-by-alphabetical-but-exclude-symbols/#findComment-1045274 Share on other sites More sharing options...
Mchl Posted April 20, 2010 Share Posted April 20, 2010 Assumin it is only a " sign you're concerned with, you can use this hack ORDER BY IF(SUBSTR(name,1,1)='"',SUBSTR(name,2,100),name) (instead of 100, you should put length of your field -1) This can be expanded to acomodate for more characters. Link to comment https://forums.phpfreaks.com/topic/195827-mysql-order-by-alphabetical-but-exclude-symbols/#findComment-1045289 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.