[H-GEN] Mysql & bitwise xor

[Paul Clarke]

[ Humbug *General* list - semi-serious discussions about Humbug and     ]
[ Unix-related topics. Posts from non-subscribed addresses will vanish. ]

Hi all,

Is it just me or does mysql not like a bitwise xor

The query:
update user set groups=groups ^ 2 where login="pmcleod"
Returns ... You have an error in your SQL syntax near '^ 2 where
login="pmcleod"' at line 1

However both the following work fine:
update user set groups=groups & 2 where login="pmcleod"  // and
update user set groups=groups | 2 where login="pmcleod"  // or

Any ideas, is there something really simple that I am missing?

I am running MySQL 3.23.49

Thanks

Paul

Site Dynamics - Paul Clarke
paul at sitedynamics.com.au
0414 367 747


--
* This is list (humbug) general handled by majordomo at lists.humbug.org.au .
* Postings to this list are only accepted from subscribed addresses of
* lists 'general' or 'general-post'.  See http://www.humbug.org.au/