Problem using the field 'from' in sql query

Question

SELECT m.id, m.title, m.message, m.from, m.to2, m.to_viewed, m.from_viewed, m.created, u.username 
FROM tbl_messages m 
INNER JOIN tbl_users u 
ON m.from = u.id WHERE m.to2 = '1' && m.to_saved = '1'  && m.to_deleted = '0' 
ORDER BY m.created DESC

Having removed m.from, the query runs. It doesn't like this field name. Is 'from' reserved? Could someone suggest a fix?

Thanks

You should use backticks [`] with the keywords that are used as a column name or table name. — Ghazanfar Mir, Sep 19 '11 at 11:54
possible duplicate of [Syntax error due to using a reserved word as a table or column name in MySQL](http://stackoverflow.com/questions/23446377/syntax-error-due-to-using-a-reserved-word-as-a-table-or-column-name-in-mysql) — Ian Ringrose, May 06 '14 at 09:56

score 3 · Answer 1 · answered Sep 19 '11 at 11:50

3

Wrap it with backticks, because it is mysql's reserved keyword

m.`from`

Here is a full list of reserved words

answered Sep 19 '11 at 11:50

zerkms

249,484
69
436
539

score 3 · Accepted Answer · answered Sep 19 '11 at 11:50

3

Yes, it's one of the reserved words. Use backticks to quote it:

m.`from`

answered Sep 19 '11 at 11:50

Mark Byers

811,555
193
1,581
1,452

score 1 · Answer 3 · answered Sep 19 '11 at 11:50

1

From is reserved, yes. You could try adding quotes around it. The easiest is to avoid using reserved words in queries.

answered Sep 19 '11 at 11:50

OptimusCrime

14,662
13
58
96

score 1 · Answer 4 · answered Sep 19 '11 at 11:51

1

Yes it is a reserved word. You should enclose from in back ticks like

m.`from`

answered Sep 19 '11 at 11:51

Jan S

1,831
15
21

score 0 · Answer 5 · answered Sep 19 '11 at 11:50

0

Yes, "from" is reserved. In mysql, IIRC you can put it in either double quotes (") or backquotes (`) (but I also use postgresql, so I may be confusing the two systems).

answered Sep 19 '11 at 11:50

Colin Fine

3,334
1
20
32

Problem using the field 'from' in sql query

5 Answers5