in reply to Re: Re: SELECT COUNT and DBI: rows
in thread SELECT COUNT and DBI: rows

... but didn't it used to be not-valid syntax? I remember having to use MySQL without the AS after I swtiched from Oracle (a few years ago).

A "few years ago" in internet time is a lifetime. You can save yourself embarrassment by checking current docs before making a "you can't do that" statement, especially on stuff you haven't used for a few years.