On Thu, Aug 01, 2002 at 06:15:16PM +0200, Joseph Bueno wrote: > > According to MySQL documentation, indexes are not used with OR: > http://www.mysql.com/doc/M/y/MySQL_indexes.html > You can't speed up your query by adding indexes. > Running 2 separate queries is the best you can do if you want to go fast.
In MySQL 4.x you could use a UNION to do it. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 63 days, processed 1,334,527,253 queries (241/sec. avg) --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php