Missed FROM clause... ;) Best regards, Mikhail.
----- Original Message ----- From: "Mário Gamito" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Friday, March 11, 2005 1:49 PM Subject: Problem in a very simple SQL statement > Hi, > > Why do i get an error on this statement: > > select count(email) where email='[EMAIL PROTECTED]'; > > The error is: > "ERROR 1064: You have an error in your SQL syntax near 'where > email='[EMAIL PROTECTED]'' at line 1" > > The statement seems pretty clear to me, but obviously something's wrong. > > What can it be ? > > Any help would be apreciated. > > Warm Regards, > Mário Gamito > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]