MySQL sort alphabetically 1

[YDDesign]

What I am trying to accomplish is alphabetical sorting daily. For example on day one I would like it to sort litings from a-z, the following day b-a, the next day c-b and so on. Once it gets to z-a the next day would be back to a-z. Is this possible? I appreciate any help I can get with this as my brain hurts thinking about how to pull this one off!

Cheers!

 

[r937]

could you please give some sample rows of data to illustrate what you mean by "b-a" and "c-b" and "z-a"

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[YDDesign]

Basically I am listing bed and breakfast locations in alphabetical order however A would get top spot always, so I would like the top position to rotate one from the bottom to the top every day,
ABCDEFGHIJKLOMOPQRSTUVWXYZ the next day ZABCDEFGHIJKLMNOPQRSTUVWXY the next day YZABCDEFGHIJKLMNOPQRSTUVWX and so on.

Hope that helps Thanks again!

 

[r937]

ORDER BY
CASE WHEN LEFT(somecol,1) >= 'Z' THEN 0 ELSE 1 END, somecol

ORDER BY
CASE WHEN LEFT(somecol,1) >= 'Y' THEN 0 ELSE 1 END, somecol

ORDER BY
CASE WHEN LEFT(somecol,1) >= 'W' THEN 0 ELSE 1 END, somecol

...

r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[ingresman]

Interesting question and answer !, my initial thoughts were a custom collation sequence would probabby work, have a look at

http://forge.mysql.com/w/images/b/b7/HowToAddACollation.pdf

or if you are using PHP look at

http://www.php.net/manual/en/array.sorting.php

at the bottom you will see uasort() uksort() and usort() which may also help

 

[YDDesign]

Awesome thank you very much!