[vox-tech] mysql 4 questions

Rod Roark rod at sunsetsystems.com
Fri Sep 10 17:28:01 PDT 2004


On Friday 10 September 2004 02:36 pm, Dylan Beaudette wrote:
...
> EXPLAIN SELECT [a bunch of columns]
>    FROM UDC
>    WHERE UDC.year IN ('2000') AND county_cd IN ('28') AND UDC.chem_code IN
> ('198');

See what happens if you use '=' instead of 'IN' (and remove
the parentheses).

-- Rod


More information about the vox-tech mailing list