Re: MySQL returns the same result using the IN clause irrespective of the value used

[Peter Brawley]

From the absence of quotes, MySQL makes the shortcut assumption that the varchar value is to be interpreted as a number, and evaluates it as a double, which obviously rounds.

To make the comparison with the value as a varchar, surround it with quotes ...

where cast(test_id) = '792718488739137399'

To make the comparison as an int, use something like ...

where cast(test_id as unsigned) = 792718488739137399