Results 1 to 2 of 2

Thread: mysql order by

  1. #1
    Join Date
    Sep 2011

    Post Unanswered: mysql order by

    we use order by clause in mysql along with a field name .

    But how does order by rand() works if no field name is provided in the query.

    are there more such 'exceptions' or is this even a exception ?

    Pls help

    Thanks in advance ..

    I have just started learning mysql so i don't know much about it....

  2. #2
    Join Date
    Apr 2002
    Toronto, Canada
    Quote Originally Posted by Chibs View Post
    ...or is this even a exception ?
    nope, RAND() doesn't need to operate on a value | @rudydotca
    Buy my SitePoint book: Simply SQL

Tags for this Thread

Posting Permissions

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