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! Quote 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. Quote 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! Quote 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! Quote 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. Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.