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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]