MySQL Forums
Forum List  »  German

Re: ORDER BY
Posted by: Hartmut Holzgraefe
Date: January 20, 2009 04:30AM

Das "ORDER BY" muss hier ganz am Ende *nach* der vollständigen WHERE-Bedingung stehen, die $searchtext-Bedingungeen müssen also zuerst angefügt werden under *erst dann* das ORDER BY.

Siehe auch "SELECT Syntax":

http://dev.mysql.com/doc/refman/5.1/en/select.html

SELECT
[...]
[FROM table_references
[WHERE where_condition]
[GROUP BY {col_name | expr | position}[ASC | DESC], ... [WITH ROLLUP]]
[HAVING where_condition]
[ORDER BY {col_name | expr | position} [ASC | DESC], ...]
[...]

--
Hartmut Holzgraefe, MySQL Regional Support Manager EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

Options: ReplyQuote


Subject
Views
Written By
Posted
9189
January 19, 2009 08:51AM
3594
January 19, 2009 10:16AM
3619
January 20, 2009 04:13AM
Re: ORDER BY
3496
January 20, 2009 04:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.