View Single Post

  #1 (permalink)  
Old 01-15-2007
Yttrium
 
Posts: n/a
Default Special query with multiples fields

Hello, (And sorry for my english, caus' I'm french)

I've got a problem with a MySql query :

SELECT *
FROM table1 as t1
WHERE (t1.field1,t1.field2,t1.field3)
IN ('a','b','c'), ('d','e','f'), ('g','h','i')

This query isn't ok, but I don't know hox to deal with this..
I want to get every lines where field1 AND field2 AND field3 is in one
of the triplet I've got...

ie:
If the line (a,b,c) is in my table, I want to get it, but if the line is
only (a,b,d), I Don't want to get it..

Perharps someone should help me to do this ?

Thanks, Regards.

And sorry again for my very bad english...

Yttrium
Reply With Quote