From: Christian Mack
Date: August 3 1999 5:41pm
Subject: Re: SQL escape
List-Archive: http://lists.mysql.com/java/255
Message-Id: <37A729AD.1066012E@compal.de>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

C Javier Castro Pena wrote:
> 
> Use \' inside the string
> 
> > Hello,
> >
> > could someone point me to the right way to escape SQL characters like '
> > using JDBC please.
> > I mean queries like "SELECT id FROM friends WHERE name = 'd'artanjan'  "
> >
> >
> > thank you in advance
> >
> > Kazys
> >
> 
> Javier.-

Or you can use the PreparedStatement syntax.

Tschau
Christian