Try '=' instead of 'LIKE'. LIKE is used for wild card pattern matching, which you don't have here.
Johan Hallenberg - LUB NetLab wrote: >Hello, >I'm experience the same problem. I use a query like this: > >SELECT publ,fak,id,COUNT(*) FROM ftxt_stat WHERE year LIKE '2001' AND >month LIKE 'Oct' GROUP BY publ,fak,id; > >If I remove COUNT(*) I don't get the error. > >The table I use look like this: > >CREATE TABLE ftxt_stat ( > year VARCHAR(255), > month VARCHAR(255), > fak VARCHAR(255), > id VARCHAR(255), > publ VARCHAR(255), >); > > > --------------------------------------------------------------------- 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