Re: Stupid dumb question about mySQL Im sure.

Try to use single quotes in your where statement delete from logfile where browser = 'some_browser'; HTH, Ernani "Liz Kimber" <liz@xcalibur.co.uk> escreveu na mensagem news:NCBBJGMGKKKPKLEHHOCOKEINCLAA.liz@xcalibur.co.uk... > OK, I have a table, such as > > CREATE TABLE logfile ( > Address varchar(255) NOT NULL, > GroupID varchar(20) NOT NULL, > UserID varchar(20) NOT NULL, > AccessDate varchar(40) NOT NULL, > Cmd varchar(255) NOT NULL, > RetCode varchar(4) NOT NULL, > Size varchar(20) NOT NULL, > Referer varchar(255) NOT NULL, > Browser varchar(255) NOT NULL, > KEY Address (Address), > KEY GroupID (GroupID), > KEY UserID (UserID), > KEY AccessDate (AccessDate), > KEY Cmd (Cmd), > KEY RetCode (RetCode), > KEY Size (Size), > KEY Referer (Referer), > KEY Referer_2 (Referer), > KEY Browser (Browser) > ); > > OK, so why does the following line not work. > > delete FROM logfile WHERE Browser="somebrowser" > > I dont get it. > > I need to strip out some stuff, the file is getting too big