Jump to content

MySQL "ORDER BY" alphabetical but exclude symbols


kristen

Recommended Posts

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!

  • 4 weeks later...

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.