Welcome to WebmasterWorld Guest from 54.144.126.195

Forum Moderators: open

Message Too Old, No Replies

Appending Data

Apending Data using SQL query

     

binarytrends

10:47 am on Oct 13, 2005 (gmt 0)

5+ Year Member



I wonder if there is any way to APPEND data to an already populated field using a SQL query. I'm presently handeling it through PHP by writing two queries.

killroy

12:38 pm on Oct 13, 2005 (gmt 0)

WebmasterWorld Senior Member 10+ Year Member



I suppose it would go like this:

UPDATE table SET field1=CONCAT(field1,' this will be appended to the end of field1') WHERE id=12345;

SN

binarytrends

7:49 am on Oct 16, 2005 (gmt 0)

5+ Year Member



Thanks killroy

coopster

12:43 am on Oct 17, 2005 (gmt 0)

WebmasterWorld Administrator coopster is a WebmasterWorld Top Contributor of All Time 10+ Year Member



That killroy supposes correctly quite often ;)

Welcome to WebmasterWorld, binarytrends.

txbakers

12:54 am on Oct 17, 2005 (gmt 0)

WebmasterWorld Senior Member txbakers is a WebmasterWorld Top Contributor of All Time 10+ Year Member



I always forget the CONCAT and try to do it with a simple ampersand and wonder why all my data disappears!

binarytrends

5:53 am on Oct 18, 2005 (gmt 0)

5+ Year Member



Hi Coopster, You must be right :)
 

Featured Threads

Hot Threads This Week

Hot Threads This Month