Andrew, Please allow a small amount of grief to come from these lists... People are usually glad to help, and Mike sent the info that he knew to you. There is a certain amount of frustration that develops when people repeatedly ask questions of the mailing list that are clearly documented in the mysql documentation. Suggesting to read the manual is not a bad thing, and RTFM is a long stading acronym that nobody on this list invented, and I guarentee everyone on this list is guilty of asking a question that is in the documentation for some product / project they were working on.
The MySQL documentation is, IMHO (in my humble opinion - another oldie acronym), incredibly good for a free product. Searching it for answers, particularly about syntax, should be everyone's, including my, first step in solving an issue that we're having. [getting down off of soap box] Dan Greene > -----Original Message----- > From: Andrew [mailto:[EMAIL PROTECTED] > Sent: Monday, November 17, 2003 1:16 PM > To: MySQL-Lista; Rodolphe Toots > Subject: RE: replace query + RTFM? > > > amazing, and you guys are errr intelligent!!! can't actually > help but you can > make an abbreviation for RTFM how f#$#$ng 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 f****ing 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]