Posted by Tom Thackrey on 05/29/05 06:35

On 28-May-2005, "Nick" <nick_1394@yahoo.com.cn> wrote:

> 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.

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
would be:

select * from InboxMessage where `To`=12


--
Tom Thackrey
www.creative-light.com
tom (at) creative (dash) light (dot) com
do NOT send email to jamesbutler@willglen.net (it's reserved for spammers)

• Next in forum: Re: How do I send HTML and a file for 'Save-As' at the same time?
• Prev in forum: Re: PHP display/install? problem Solution
• Thread view: Re: How to corret this mysql select query?

[Reply to this message]