A Date and Select question.

Mytable WHERE Date = 'WWW'; it gives me the result: 2 John -00-00 John's project I think it should not return any values. Why? Thanks. I. TS. - Before posting, please check: http

Date and Select problem

Mytable WHERE Date = 'WWW'; it gives me the result: 2 John -00-00 John's project I think it should not return any rows. Why? Thanks. I. TS - Before posting, please check: http

A date problem

Mytable WHERE Date = 'WWW'; it gives me the result: 2 John -00-00 John's project think it should not return any rows. Why? Thanks. I. TS - Before posting, please check: http://www.mysql.com

when column contains spaces

I am a newbie. When I create a table, when one column contains a space, how can I create it correctly in mysql? for example: CREATE TABLE mytable( name CHAR(60) NOT NULL, this column CHAR(60) ///Here there is a space? ); When I use ' or , it does not

A space is contained in colum??

I am a newbie. When I create a table, one colum contains a space, how can I caeate it correctly? like: CREATE TABLE mytable( name CHAR(60) NOT NULL, Email VARCHAR(50) NOT NULL, Thrid colum CHAR(60), ///Here there is a space? PRIMARY KEY (Email) );