Re: editing part of a field

Hi, But won't update update the what I input. I only need PART of the post to update, only the selected url area and want the remaining of the message to be unchanged. Won't the update change the whole message? I think it does, I only need part of the message to be edited and that is the URL the text needs to be unchanged. I have over 9,000 posts to update and fix the image url for it. I can't afford to muddle up the posts. Jerry From: "Jason Wong" <php-db@gremlins.biz> To: php-db@lists.php.net Date: Thu, 17 Jul 2003 13:43:17 +0800 Subject: Re: [PHP-DB] editing part of a fiedl! On Thursday 17 July 2003 12:28, JeRRy wrote: > So something like this: > > Hi bob <img src="domain.com/emotions/board/laugh.gif"> > all is well, cya! > > So old posts have the wrong image location but new > posts show the correct place to the image as it's > configured to do it but old posts since they are > already in the database show up wrong. > > Is there a way to edit _part_ of the post. To fix the > image url. Is there a mysql query I can use to edit > where board/emotions with /emotions? Use an UPDATE query. -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * ------------------------------------------ Search the list archives before you post http://marc.theaimsgroup.com/?l=php-db ------------------------------------------ /* The little pieces of my life I give to you, with love, to make a quilt to keep away the cold. */ http://mobile.yahoo.com.au - Yahoo! Mobile - Check & compose your email via SMS on your Telstra or Vodafone mobile.