IF you have a version of MySQL that is recent enough (4.0+) you can merge
your two queries *when you run them* by using the UNION predicate.
http://dev.mysql.com/doc/mysql/en/UNION.html
Much better than a client-side merge.
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"D
Thanks for the suggestions over the weekend! I will be looking in to
this in a few days - for now I think I am just going to have to re-write
my PHP script to make 2 separate queries and array_merge() them - which
invariably seems to solve "OR" problems. But there should be a better
way, no?
-Da
At 06:03 PM 10/1/2004, you wrote:
Wondering if anyone can give me advice on indexing for OR clauses.
I have a table with a number of fields, two of which are sender_id and
receiver_id. I also have a query such as this:
SELECT ...
WHERE (sender_id = 98765 OR reciever_id = 98765)
The query is OK for
