Re: OR in query doesn't use keys?

[Bill Marrs]

At 01:54 PM 2/17/2004, walt wrote:
>> (SELECT FROM table WHERE condition1) UNION (SELECT FROM table WHERE
>> condition2);
Ah, interesting... I'll play around with UNION to see if that will do the 
trick for me.

Right off the bat, I am able to get a fast query with it, but the output 
isn't quite, right (though, I can probably massage it to be workable).

mysql> (SELECT count(*) FROM Trades WHERE User1 = 79909) UNION (SELECT 
count(*) FROM Trades WHERE User2 = 79909);
+----------+
| count(*) |
+----------+
|       22 |
|       33 |
+----------+
2 rows in set (0.01 sec)

Thanks.

-bill

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]