Is that a character field? If it is, you forgot the quotes, and the string was converted to a number. 16 significant digits match.
Joakim Ryden wrote:
Hey folks -
can anyone explain this behaviour:
mysql> select token, spam_hits, innocent_hits from dspam_token_data where uid=500 and token=14243385100413148122;
Returns this result, which is a completely different record.
+---------------------------+-------------+----------------+ | token | spam_hits | innocent_hits | +---------------------------+-------------+----------------+ | 14243385100413147136 | 0 | 1 | +---------------------------+-------------+----------------+
??
--Jo
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]