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....

nope, RAND() doesn't need to operate on a value