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
|