List:General Discussion« Previous MessageNext Message »
From:Ray Date:June 20 2003 2:09pm
Subject:Re: wierd sort query, how do you do it? (sort by ip proximity guess)
View as plain text  
select 8 ^ 5;
ERROR 1064: You have an error in your SQL syntax near '^ 5' at line 1

i'm guessing that this means mysql 3.23 doesn't have the xor.

On Thursday 19 June 2003 11:52, Nicholas Elliott wrote:
> Remember that this is a binary XOR, not a logical XOR.  Mysql does have a
> binary XOR operator, the '^' operator.  So 'ipAddress1 ^ ipAddress2' is the
> binary XOR between the two values.  The binary AND is the '&' operator and
> the binary OR is the '|'.  Just don't confuse them with the AND operator
> and/or the OR operator.
>
> Got all that? =)
>
> Nick Elliott
>
>
Thread
wierd sort query, how do you do it? (sort by ip proximity guess)Ray19 Jun
  • RE: wierd sort query, how do you do it? (sort by ip proximity guess)Matthew Smith19 Jun
    • Re: wierd sort query, how do you do it? (sort by ip proximity guess)Ray19 Jun
    • Re: wierd sort query, how do you do it? (sort by ip proximity guess)Ray19 Jun
    • Re: wierd sort query, how do you do it? (sort by ip proximity guess)Nicholas Elliott19 Jun
      • Re: wierd sort query, how do you do it? (sort by ip proximity guess)Ray20 Jun
        • Re: wierd sort query, how do you do it? (sort by ip proximity guess)Fred van Engen20 Jun