Hi, You can't use aliases in a where, but you can in a HAVING clause. Regards Quentin -----Original Message----- From: Brad Barnett [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 10 April 2001 8:44 a.m. To: [EMAIL PROTECTED] Subject: Strange queries SELECT url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful lname,MATCH newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category LEFT JOIN userrestrictions ON userrestrictions.name REGEXP '[[:<:]]username|GLOBALAUTHADMIN[[:>:]]' AND newwebsites.catid=userrestrictions.catid where category.catid=newwebsites.catid AND userrestrictions.catid IS NULL AND category.groupid<='1' ORDER BY newwebsites.groupid DESC limit 10; Can anyone tell me why the above query works, and responds with a column labelled "GOO", but if I take the exact same query, and add "AND GOO > 0" to it, it complains that there is : ERROR 1054: Unknown column 'GOO' in 'where clause' What gives? If the column GOO exists when MYSQL does an output from that query, why can't I address it in the query? Thanks for any help anyone may have! Quoting Andrew Schmidt <[EMAIL PROTECTED]>: > Have you tried this under a 'stable' version of freebsd? > > In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's > fault. > > now, I understand RC's are generally stable; but I would still make sure > that this bug doesn't show up in a stable os. > > regards, > > -- Andrew > > ----- Original Message ----- > From: <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Monday, April 09, 2001 3:34 PM > Subject: mysql uses 99% cpu under freebsd 4.3 > > > > >Description: > > mysql uses 99% cpu and becomes extremely unresponsive under high load > > > > >How-To-Repeat: > > send about 300 simultaneous visitors to www.chicagobusiness.com and > tell > them to click around. > > > > > > >Fix: > > restart mysql. this usally helps, at least for a few minutes. > sometimes > it climbs back to 99% though. > > > > >Submitter-Id: <submitter ID> > > >Originator: Jon Nathan > > >Organization: > > Chaffee Interactive > > >MySQL support: extended email support > > >Synopsis: mysql uses 99% cpu and becomes unresponsive > > >Severity: serious > > >Priority: high > > >Category: mysql > > >Class: support > > >Release: mysql-3.23.36 (Source distribution) from freebsd ports > > > > >Environment: > > System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3 > 16:17:52 > GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386 > > > > > > Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc > > GCC: Using builtin specs. > > gcc version 2.95.2 19991024 (release) > > Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++' > CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti > -fno-except > ions' LDFLAGS='' > > LIBC: > > -r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a > > lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so -> > libc.so.4 > > -r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4 > > Configure command: > ./configure --localstatedir=/data/db --without-perl --without-debug > --witho > ut-readline --without-bench --with-mit-threads=no --with-libwrap > --with-low- > memory --enable-assembler --with-berkeley-db --with-charset=latin1 > --prefix= > /usr/local i386--freebsd4.3 > > Perl: This is perl, version 5.005_03 built for i386-freebsd > > > > --------------------------------------------------------------------- > > Before posting, please check: > > http://www.mysql.com/manual.php (the manual) > > http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > --- Dynamic Hosting HTTP://www.L8R.net/ "We Provide Static Hostnames for Dynamic IP's" --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
