Hi Mike I really appreciate you getting back to me so quickly :)
Can I just clarify this becuse I have over 4000 records and not all of the records have anything in items - description but there are about 2500 records with this exact text-> <br />A-Z Business Directory <br /><br /> Please call 0116 27 960 41 for further details <br /><br /> Replace these details with yours simply by calling 0116 27 960 41 <br /><br /> Unlike YELL we only list a maximum of 5 businesses per Business Category <br /><br /> The chances of your business being called has been increased already. Be Seen by calling 0116 27 960 41 or <br /><br /><A HREF="http://www.punterspower.co.uk/register_online.php">registering online</A><br /><br /><ul><li>No Web Site needed</li><li>No Internet knowledge required</li><li>All administration carried out by us</li><li>All contacts forwarded to you</li><li>Comprehensive Company details</li><li>Link to your own web site</li><li>You can add html within your description making your profile suit</li><li>Login access to administer and change you details whenever you need to</li></ul> and it just the telephone I want to change :) so is the correct query> REPLACE items SET description="new telphone number" WHERE (old telephone number) Thank you so much Andrew PS what does RTFM mean? >-----Original Message----- >From: Mikael Fridh [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 17:12 >To: [EMAIL PROTECTED]; MySQL-Lista >Subject: Re: replace query > > >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] > > >--- >Incoming mail is certified Virus Free. >Checked by AVG anti-virus system (http://www.grisoft.com). >Version: 6.0.541 / Virus Database: 335 - Release Date: 14/11/2003 > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]