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] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]