>Looks to me like you want to use UPDATE instead. Specify a WHERE clause >that identifies the rows you want to update, and in the SET clause specify >the new value for the description column. > >To pre-flight your UPDATE, you can write a SELECT that has the same WHERE >clause. This will show you whether or not you are indeed identifying the >proper rows. >
thank you paul Indeed I think you are right and if memory serves me correct you supplied my solution the first time ;) I thought I had saved the query for the next time I needed it! As it happens I can't find it. I'll have a read on the UPDATE and see if I can work it out. Thank you Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]