1. Forum
  2. Usenet
  3. COMP.DATABASES.MYSQL

  • sort odd/even

    From [email protected]@21:1/5 to All on Fri Jan 10 12:04:12 2020
    Tried concat the three fields and still same


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Fri Jan 10 11:42:02 2020
    order by street, house, if(mod(right(trim(house),1),2)=0,0,1)

    I printed out mod(..) and it is ok but it won't sort by it

    is it possible it only sorts on two and no more keys?

    It worked on Microsoft

    Tried several variants


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From [email protected]@21:1/5 to All on Fri Jan 10 12:11:19 2020
    Got it to work by using only first three chars of house and street.
    Kinda lame, but it worked.


    - = -
    Vasos Panagiotopoulos, Columbia'81+, Reagan, Mozart, Pindus
    blog: panix.com/~vjp2/ruminatn.htm - = - web: panix.com/~vjp2/vasos.htm
    facebook.com/vasjpan2 - linkedin.com/in/vasjpan02 - biostrategist.com
    ---{Nothing herein constitutes advice. Everything fully disclaimed.}---

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)