Worked like a dream Dan Thanks Paul for being patient :)
Thank you Andrew >-----Original Message----- >From: Dan Greene [mailto:[EMAIL PROTECTED] >Sent: 17 November 2003 21:27 >To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista >Subject: RE: replace query + RTFM? > > >you need to tell mysql what field to equate to the value in your where clause: > >update items set ItemDescription = '<new text>' >where ItemDescription = '<old text>' > >replacing the < > items with the text you have below .... > >> -----Original Message----- >> From: Andrew [mailto:[EMAIL PROTECTED] >> Sent: Monday, November 17, 2003 4:19 PM >> To: [EMAIL PROTECTED]; Mikael Fridh; MySQL-Lista >> Subject: RE: replace query + RTFM? >> >> >> >> >> Can someone kindly tell me what I doing wrong and help with >> this query? >> >> I want to replace / update the text for every record within >> table items field >> ItemDescription. This is what I have so far and its isn't corroect :( >> >> UPDATE items SET ItemDescription='A-Z Business Directory <br >> /><br /> Please >> call 0870 199 4080 for further details <br /><br /> Replace >> these details simply >> by calling 0870 199 4080 <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 0870 >> 199 4080' WHERE 'A-Z >> Business Directory <br /><br /> Please call 0116 27 960 41 >> for further details >> <br /><br /> Replace these details 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' >> >> Andrew >> >> >> -- >> 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]
