"Thomas Sundberg" <[EMAIL PROTECTED]> wrote on 04/02/2005
12:46:02:
>
> > > Does anybody at the list know the answer to my question? I
> > sent it a
> > > few days ago and haven't received any response. It does
> > exist a syntax
> > diagram
> > > for MySQL, doesn't it?
> >
> > Since no-one replied to your first post, apparently not. I
> > have never seen such a thing.
>
> Strange, where is the definition for the syntax element
"where_definition"
> done then? That is the part of the syntax diagram I currently looking
for.
> It is defined as an element in the select syntax diagram. But when
trying to
> find the definition for what is legal to put in a where clause, I just
can't
> find it.
>
> Could somebody point in me the correct direction?
The WHERE keyword is followed by an "expression". There appears to be no
no formal definition of "expression", but it could be informally defined
as the a combination of Operatiors applied to column names and constants.
See manual chapter 12: Operators. The WHERE clause restricts to rows where
the expression returns true.
Alec Cawley.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
