In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
My exact problem is I want to select some records that have a
dotted IP address as one of the fields. And I want to filter out
the multicast
PROTECTED]
Sent: Wednesday, March 05, 2003 6:17 PM
Subject: HAVING vs. WHERE
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
My exact problem is I want to select some records that have
At 11:17 -0500 3/5/03, Jonathan Arnold wrote:
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
If a test can be in either clause, put it in the WHERE clause. The principle
is that the sooner you
: Wednesday, March 05, 2003 11:17 AM
Subject: HAVING vs. WHERE
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
My exact problem is I want to select some records that have a
dotted IP address as one
On Wed 2003-03-05 at 11:17:37 -0500, [EMAIL PROTECTED] wrote:
In the MySQL reference, it warns against using HAVING for items
that should be in a WHERE clause. I'm not sure what items
should be in a WHERE clause.
Everything except stuff that only works when it's in the HAVING
clause. The
In the last episode (Mar 05), Jonathan Arnold said:
In the MySQL reference, it warns against using HAVING for items that
should be in a WHERE clause. I'm not sure what items should be in
a WHERE clause.
The WHERE clause is used to restrict records, and is also used by the
query optimizer to