On Fri, Jun 20, 2003 at 09:09:50AM -0500, Ray wrote: > 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. >
It was added in 4.0.2 according to the docs. Try this: mysql> select version(); +-------------+ | version() | +-------------+ | 3.23.52-log | +-------------+ 1 row in set (0.00 sec) mysql> select (5 | 8) & ~(5 & 8); +--------------------+ | (5 | 8) & ~(5 & 8) | +--------------------+ | 13 | +--------------------+ 1 row in set (0.00 sec) mysql> select (5 | 7) & ~(5 & 7); +--------------------+ | (5 | 7) & ~(5 & 7) | +--------------------+ | 2 | +--------------------+ 1 row in set (0.00 sec) mysql> Regards, Fred. -- Fred van Engen XB Networks B.V. email: [EMAIL PROTECTED] Televisieweg 2 tel: +31 36 5462400 1322 AC Almere fax: +31 36 5462424 The Netherlands -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
