1. Forum
  2. USENET
  3. comp.databases.mysql

  • order by replace mod (from MySql to OODB)

    From vjp2.at@vjp2.at@at.BioStrategist.dot.dot.com to comp.databases.mysql on Thu Feb 13 22:37:57 2020
    From Newsgroup: comp.databases.mysql

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




    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Luuk@luuk@invalid.lan to comp.databases.mysql on Sat Feb 15 12:09:39 2020
    From Newsgroup: comp.databases.mysql

    On 13-2-2020 23:37, 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.}---





    It seems to be more this problem:
    mysql> set @a="straat 12"; select @a, replace(@a, "-", cstr(cint( RIGHT( RTRIM( @a ), 1)) mod 2));
    Query OK, 0 rows affected (0.00 sec)

    ERROR 1305 (42000): FUNCTION test.cstr does not exist
    mysql>


    But can you share some example input data, and a description on what you
    are trying to achieve (with some output data)?
    --
    Luuk
    --- Synchronet 3.21d-Linux NewsLink 1.2
  • From Jerry Stuckle@jstucklex@attglobal.net to comp.databases.mysql on Sat Feb 15 19:10:35 2020
    From Newsgroup: comp.databases.mysql

    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
    ==================
    --- Synchronet 3.21d-Linux NewsLink 1.2