Re: [vox-tech] mysql 4 questions

To: dylan@iiMAPSci.no-ip.org,lugod's technical discussion forum <vox-tech@lists.lMAPSugod.org>
Subject: Re: [vox-tech] mysql 4 questions
From: Rod Roark <rod@sMAPSunsetsystems.com>
Date: Fri, 10 Sep 2004 17:28:01 -0700
Cc:
Delivered-to: lugod@livepenguin.com
Delivered-to: vox-tech@livepenguin.com
In-reply-to: <1764.169.237.35.163.1094852195.squirrel@iici.no-ip.org>
List-archive: <http://ns1.livepenguin.com/pipermail/vox-tech>
List-help: <mailto:vox-tech-request@lists.lugod.org?subject=help>
List-id: lugod's technical discussion forum <vox-tech.lists.lugod.org>
List-post: <mailto:vox-tech@lists.lugod.org>
List-subscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:vox-tech-request@lists.lugod.org?subject=subscribe>
List-unsubscribe: <http://lists.lugod.org/mailman/listinfo/vox-tech>,<mailto:vox-tech-request@lists.lugod.org?subject=unsubscribe>
References: <1764.169.237.35.163.1094852195.squirrel@iici.no-ip.org>
Reply-to: lugod's technical discussion forum <vox-MAPStech@lists.lugod.org>
Sender: voMAPSx-tech-bounces@lists.lugod.org
User-agent: KMail/1.6.2

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
_______________________________________________
vox-tech mailing list
vox-tech@lists.lugod.org
http://lists.lugod.org/mailman/listinfo/vox-tech

Follow-Ups:
- Re: [vox-tech] mysql 4 questions [solved]
  - From: dylan

References:
- [vox-tech] mysql 4 questions
  - From: Dylan Beaudette

Prev by Date: [vox-tech] mysql 4 questions
Next by Date: [vox-tech] [OT] JavaScript / HTML Help: Popup windows and forms
Previous by thread: [vox-tech] mysql 4 questions
Next by thread: Re: [vox-tech] mysql 4 questions [solved]
Index(es):
- Date
- Thread

Hosting provided by:
Sunset Systems
Sunset Systems offers preconfigured Linux systems, remote system administration and custom software development.

LUGOD: Linux Users' Group of Davis
1105 Kennedy Place, Suite 1, Davis, CA 95616
Contact Us

LUGOD is a 501(c)7 non-profit organization
based in Davis, California
and serving the Sacramento area.
"Linux" is a trademark of Linus Torvalds.