On Monday 17 November 2003 18.04, Andrew wrote: > I have a MySQL database with records in a table that i would like to > replace. The table is > > items and the field is description. I would like to replace the existing > text within this filed with some new text. > > I did this before and it was successful but I have lost the query to do it > :( > > Could someone shed some light in this please :) > > Andrew
http://www.mysql.com/doc/en/Data_Manipulation.html REPLACE items SET description="RTFM" WHERE ...(insert your where clause here) Mike -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]