MySQL: match any x of y conditions?

[TruckStuff]

I'm really not even sure what this would be called, so I can't even begin to search for answers.😕

Suppose I have a data set that I need to match any 2 of several conditions. Can I do this in a single query, or does it need to be split through several queries? For example, if I have the following data:

Row  Col1  Col2  Col3  Col4  Col5
===  ====  ====  ====  ====  ====
1     A     B     C     D     E
2     A     C     B     D     A
3     B     C     D     E     A

I want to match rows where any two (or more) of the following conditions are met: (Col1=='A' || Col2=='B' || Col4=='D'). The result set would return rows 1 and 2 only. Does this make any sense at all??

[razz]

Try this idea:

$col11_match = 'A';
$col12_match = 'B;
$col13_match = 'D';

$query = "SELECT * FROM table WHERE col11 ='$col11_match' OR col12='$col12_match' OR col13='D$col13_match ";

Hope it helps,

razz