Welcome to the JaguarPC Community
JaguarPC
Sales: (888) 338-5261
Support: (888)-551-3050
Results 1 to 2 of 2

This is a discussion on Order of WHERE clauses in the Shared & Semi-Dedicated forum
Ok this is something I've wondered about for a while but I've never come across the answer. Does MySQL process WHERE clauses in the order ...

  1. #1
    Just Walking...
    Join Date
    Oct 2002
    Location
    England
    Posts
    436

    Order of WHERE clauses

    Ok this is something I've wondered about for a while but I've never come across the answer. Does MySQL process WHERE clauses in the order they are given in a select/update string or not?

    I ask because if they are processed in the order given in a SELECT string then this will impact efficiency, therefore it would be useful to know so I can improve my scipts.
    Last edited by G.Bloke; 06-30-2003 at 05:02 AM.

  2. #2
    Jag Veteran
    Join Date
    Sep 2002
    Posts
    650
    In mysql tool, precede a SELECT statement with EXPLAIN to get information about a SELECT.

    More here: http://www.mysql.com/doc/en/EXPLAIN.html

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •