On Monday 17 November 2003 01:18 pm, Andrew wrote: > 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 ItemDescription= >'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' should do it. gabe. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]