amazing, and you guys are errr intelligent!!! can't actually help but you can make an abbreviation for RTFM how fucking sad is that, what a bunch of pathetic losers.
>-----Original Message----- >From: Rodolphe Toots [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 18:11 >To: [EMAIL PROTECTED] >Subject: SV: replace query + RTFM? > > >RTFM = "read the fucking manual".. > >-----Ursprungligt meddelande----- >Från: Andrew [mailto:[EMAIL PROTECTED] >Skickat: den 17 november 2003 18:55 >Till: Mikael Fridh; [EMAIL PROTECTED]; MySQL-Lista >Ämne: RE: replace query + RTFM? > > >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] > > > >--- >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]