Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Posted on
- How to corret this mysql select query?
May 29, 2005, 1:03 am
rate this thread
I convert some code from access to mysql. And I have a InboxMessage
table which has From and To field.
So, the query is like:
select * from InboxMessage where To=12
12 is user id.
This query works fine in access. But does not work in Mysql.
I think the problem is the field To, which must be a keyword in mysql.
So, how to fix this? I don't want to change the field, becuase this
will need to change a lot of code.
Thanks and have a great day!
Re: How to corret this mysql select query?
to is indeed a reserved word for mysql. Reserved words can be enclosed in
back-ticks (not apostrophes) to use them as column names, so your query
select * from InboxMessage where `To`=12
tom (at) creative (dash) light (dot) com
do NOT send email to email@example.com (it's reserved for spammers)