Hi there,
I'm using mysql 3.22.27. How can I force mysql to use index's in my select
statement?
When I use explain to see what the optimiser is doing I see that its using the
wrong index. When I try to use the USE INDEX(KEY1,KEY) i get a syntax error.
Any ideas
Thanks,
Pat
Pat Militzer
Tech Support Supervisor
Metro/MLS Inc.
11430 W North Ave
Wauwatosa, WI 53226
414-778-5400 ext. 124
Fax 778-6143
email: [EMAIL PROTECTED]
web site: www.metromls.com
www.wihomes.com
---------------------------------------------------------------------
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
