From: Martijn Tonies
Date: August 13 2004 8:41am
Subject: Re: quoting keywords
List-Archive: http://lists.mysql.com/mysql/170908
Message-Id: <01a601c48111$6441d680$0a02a8c0@martijn>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> Hopefully a simple problem!? ...
>
> MySQL produces a server-error when performing a query like
>
> SELECT char FROM mytable WHERE id=4711
>
> This seems to be 'char' is a MySQL-keyword. Ok!
> But how can i quote it??? (I could not find any information about this
> issue in the documentation...)

Using "backticks" should work:

select `char` from mytable

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server.
Upscene Productions
http://www.upscene.com