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
– Ghazanfar Mir, Commented Sep 19, 2011 at 11:54
possible duplicate of Syntax error due to using a reserved word as a table or column name in MySQL — Ian Ringrose
– Ian Ringrose, Commented May 6, 2014 at 9:56

Mark Byers · Accepted Answer · 2011-09-19 11:50:30Z

3

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

m.`from`

answered Sep 19, 2011 at 11:50

Mark Byers

844k202 gold badges1.6k silver badges1.5k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

zerkms · Accepted Answer · 2011-09-19 11:50:16Z

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, 2011 at 11:50

zerkms

256k73 gold badges447 silver badges551 bronze badges

Comments

OptimusCrime · Accepted Answer · 2011-09-19 11:50:21Z

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, 2011 at 11:50

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Comments

Jan S · Accepted Answer · 2011-09-19 11:51:02Z

1

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

m.`from`

answered Sep 19, 2011 at 11:51

Jan S

1,83715 silver badges21 bronze badges

Comments

Colin Fine · Accepted Answer · 2011-09-19 11:50:52Z

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, 2011 at 11:50

Colin Fine

3,3641 gold badge22 silver badges34 bronze badges

Collectives™ on Stack Overflow

Problem using the field 'from' in sql query

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related