From: Martijn Tonies
Date: November 13 2003 5:23pm
Subject: Re: problem running the following query
List-Archive: http://lists.mysql.com/mysql/153779
Message-Id: <013001c3aa0a$e86cb8a0$0a02a8c0@seal>
MIME-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

Hi,

> I am using mySQL on windows 98 machine.
> In my (java)program I want to run the following query
>
>  query = "Select * from kids_books where item_id = 'itemId' ";

You are comparing values in column "item_id" with the string
'itemId'. I guess this is not what you want, is it?


With regards,

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