counterpart for IN( ) ??

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
waskelton4
Forum Contributor
Posts: 132
Joined: Mon Sep 09, 2002 6:42 pm

counterpart for IN( ) ??

Post by waskelton4 »

Hello..

IN(var1, var2, var3, var4) returns values that are var1 or var2 or var3 or var4

is there a counterpart to IN that will return values that are var1 AND var2 AND var3 AND var4 ??

Thanks
Will
User avatar
feyd
Neighborhood Spidermoddy
Posts: 31559
Joined: Mon Mar 29, 2004 3:24 pm
Location: Bothell, Washington, USA

Post by feyd »

uhm... that would never return a single record when 2 or more values were supplied. Basically, a single field cannot be 4 values at the same time.
waskelton4
Forum Contributor
Posts: 132
Joined: Mon Sep 09, 2002 6:42 pm

Post by waskelton4 »

Yeah..

I think i figured that out after a little more thinking..

wonder if i can just delete this thread as to not leave any "evedince" laying around

:)

ws
Post Reply