Re: Select statement driving me crazy

[colbey]

mysql> describe test5;
+---------+-------------+------+-----+---------+-------+
| Field   | Type        | Null | Key | Default | Extra |
+---------+-------------+------+-----+---------+-------+
| userid  | varchar(20) |      |     |         |       |
| email   | varchar(80) |      |     |         |       |
| subject | varchar(80) |      |     |         |       |
| message | varchar(40) |      |     |         |       |
| date    | varchar(15) |      |     |         |       |
| sendby  | varchar(20) |      |     |         |       |
| code    | varchar(40) |      |     |         |       |
+---------+-------------+------+-----+---------+-------+
7 rows in set (0.01 sec)


mysql> select userid, email, date from test5 where userid = "test";
Empty set (0.00 sec)

If mysql couldn't do this.. we'd all be in deep doodoo..


On Tue, 27 May 2003, Anthony Ward wrote:

> Hi,
>
> no Date is not a reserved word
> http://www.mysql.com/doc/en/Reserved_words.html
> the problem seems to be i can only do
> SELECT *  or SELECT only_one_column_name.
>
> Anthony
>
>