Re: wierd sort query, how do you do it? (sort by ip proximity guess)

[Ray]

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