HAVING vs. WHERE

2003-03-05 Thread Jonathan Arnold
ELECT *,left(inetAdr,instr(inetAdr,".")) as ia FROM Client HAVING ia < 224 OR ia > 239 and it is a little cleaner, although as I'm going to be doing this in a PHP script, cleanliness isn't all that important. So I guess I have 2 questions: 1] Which should I use? 2] I

Re: digest mode for mysql list

2003-02-20 Thread Jonathan Arnold
ubscribe to the digest list. You can do the subscribe here: http://www.mysql.com/documentation/lists.php -- Jonathan Arnold (mailto:[EMAIL PROTECTED]) Amazing Developments http://www.buddydog.org It ain't what you don't know that gets you into trouble. It's what you kn