Corin Hartland-Swann wrote:
> SELECT * FROM foo WHERE char_field = '96' AND int_field = 1;
>
> SELECT * FROM foo WHERE char_field = 96 AND int_field = 1;
>
> Is it the expected behaviour for the second query to perform a numerical
> equivalence test on every row in the table in turn? It is
Hi there,
I am performing the following queries on a pretty large table (51 million
rows, myisampacked, couple of gigs):
SELECT * FROM foo WHERE char_field = '96' AND int_field = 1;
SELECT * FROM foo WHERE char_field = 96 AND int_field = 1;
Is it the expected behaviour for the second quer
