logical operators issue?

[Wade]

Hello,
I have a query about 17'000 characters long being glued together from a php-script. It is basically a select over a few tables using joins with some "where"-clauses and alot of "OR" clauses.

Example: and t6.fir="480" or t6.sod1a=8329 and t6.fir="480") or (t6.soc1a=11071 and t6.fir="490" or t6.son1a=11071 and t6.fir="490" or t6.sod1a=11071 and t6.fir="490") or (t6.soc1a=5009 and t6.fir="666" or t6.son1a=5009 and t6.fir="666" or t6.sod1a=5009 and t6.fir="666") or (t6.soc1a=4677 and t6.fir="450" or t6.son1a=4677 and t6.fir="450" or t6.sod1a=4677 and t6.fir="450") or ...

basically the problem can be reduced to this sample query

Select A from table where B=1 and C=2 or D=4 or E=5 or F=6

so, which of the hundreds of OR-clauses did trigger. Is there any way to find out which field trigge -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --

[Hary]

You can turn a series of logical expressions into a bitfield:

SELECT A, CONV(CONCAT(b=1, c=2, d=4, e=5, f=6), 2, 2)
FROM table WHERE B=1 AND C=2 OR D=4 OR E=5 OR F=6 -- This message may have been cut off and the rest will only be shown to members. To become a member, click here --