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

  • order by replace mod (from MySql to OODB)

    From vjp2.at@at.BioStrategist.dot.dot.co@21:1/5 to All on Thu Feb 13 22:37:57 2020
    I don't think Open Office likes mod or replace in th eorder by field

    Any clues?

    SELECT `lname`, `fname`, `adr`, `street` FROM `QUEENS_20200129` WHERE `lastvote` > '20150000' AND `asbl` = '26' AND `ed` = '3' AND `party` = 'rep' ORDER BY `street` , replace(`adr`, "-", cstr(cint( RIGHT( RTRIM( `adr` ), 1
    )) mod 2))


    - = -
    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 Jerry Stuckle@21:1/5 to vjp2.at@at.BioStrategist.dot.dot.co on Sat Feb 15 19:10:35 2020
    On 2/13/2020 5:37 PM, vjp2.at@at.BioStrategist.dot.dot.com wrote:
    I don't think Open Office likes mod or replace in th eorder by field

    Any clues?

    SELECT `lname`, `fname`, `adr`, `street` FROM `QUEENS_20200129` WHERE `lastvote` > '20150000' AND `asbl` = '26' AND `ed` = '3' AND `party` = 'rep' ORDER BY `street` , replace(`adr`, "-", cstr(cint( RIGHT( RTRIM( `adr` ), 1 )) mod 2))


    - = -
    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.}---





    What do you get for error messages? What database manager are you using?

    --
    ==================
    Remove the "x" from my email address
    Jerry Stuckle
    jstucklex@attglobal.net
    ==================

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