X-Original-To: pgsql-docs@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 23A2F47632B for ; Mon, 5 May 2003 13:00:46 -0400 (EDT) Received: from localhost.localdomain (unknown [65.217.53.66]) by postgresql.org (Postfix) with ESMTP id 3BCE1476085 for ; Mon, 5 May 2003 13:00:42 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h45HixF0010480; Mon, 5 May 2003 13:45:00 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h45H0OC13443; Mon, 5 May 2003 13:00:24 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 2YCPXSGZ; Mon, 5 May 2003 13:00:22 -0400 Subject: Re: replacing a word in a column From: Robert Treat To: torkian@ce.sharif.edu Cc: pgsql-docs@postgresql.org In-Reply-To: <2433.81.31.164.33.1051955998.squirrel@ce.sharif.edu> References: <2433.81.31.164.33.1051955998.squirrel@ce.sharif.edu> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 05 May 2003 13:00:23 -0400 Message-Id: <1052154023.30185.19.camel@camel> Mime-Version: 1.0 X-Spam-Status: No, hits=-38.0 required=5.0 tests=BAYES_10,EMAIL_ATTRIBUTION,IN_REP_TO,QUOTED_EMAIL_TEXT, REFERENCES,REPLY_WITH_QUOTES,USER_AGENT_XIMIAN autolearn=ham version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200305/3 X-Sequence-Number: 1773 I'm pretty sure you can do this, but you need to install postgresql first. :-) Robert Treat On Sat, 2003-05-03 at 05:59, Dollar $ wrote: > Hello everybody, > > Sorry if my question is too easy, > > Can I search after a word in a column and replace it with another word > just using queries?? > I'm using PHP and MySQL database. > > e.g: > > my name is payam --> my name was payam > > any help? > thanks, > payam. > > > ---------------------------(end of broadcast)--------------------------- > TIP 4: Don't 'kill -9' the postmaster