MySQL 5- error with insert that works in MySQL < 5

[AP81]

I have a query that previously worked in MySQL version 4.1.12:

SELECT MANUFACTURE, INSTRUCTIONS, UPGRADE, RECALL, CATEGORY_1, CATEGORY_2, CATEGORY_3, CATEGORY_4, CATEGORY_5, CATEGORY_6, CATEGORY_7, CATEGORY_8, CATEGORY_9, CATEGORY_10 FROM dispatch WHERE item = 'ADDR01'

This does not work on my new server (5.0.22). I did find that this query below works, the only difference being that I have changed UPGRADE to `UPGRADE` in the select statement (as shown below).

SELECT MANUFACTURE, INSTRUCTIONS, `UPGRADE`, RECALL, CATEGORY_1, CATEGORY_2, CATEGORY_3, CATEGORY_4, CATEGORY_5, CATEGORY_6, CATEGORY_7, CATEGORY_8, CATEGORY_9, CATEGORY_10 FROM dispatch WHERE item = 'ADDR01'

Any ideas on what the problem is?

Thanks,
Adam

_______________________________
There's no place like 127.0.0.1
_______________________________

 

[r937]

mysql doesn't like it unless you use backticks?

maybe it's a reserved word

which is weird, because it's not on the list of reserved words

r937.com | rudy.ca