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]