Internet Marketing Forum

For Webmasters and Entrepreneurs

Welcome, Guest. Please login or register.
Did you miss your activation email?
May 21, 2012, 02:54:56 PM

I studied the lives of great men and famous women, and I found that the men and women who got to the top were those who did the jobs they had in hand, with everything they had of energy and enthusiasm.

- Henry Truman

Home

Privacy

Internet Marketing Forum > Online Business Discussions > Website Design and Maintenance > Database

MySql - Add to text field in update statement

0 Members and 2 Guests are viewing this topic.

Pages: [1]

Author

Topic: MySql - Add to text field in update statement (Read 2356 times)

GaryGyjax

Junior Member

Joined: Oct 2007
Posts: 55

$View GaryGyjax\s Profile$

United States

Dec 01, 2007, 01:21:26 PM

I want to know if this syntax is correct before I try anything. I have a field with info in it all ready and I want to add a string to every entree. Is this correct syntax. if not what is. I couldn't find it in the docs.

update table set field = field + 'this is the string';

anyone??

Free Ringtones Sign Language Books

BrunoBertoli

Beginner

Joined: Oct 2007
Posts: 33

$View BrunoBertoli\s Profile$
BrunoBertoli is from Italy

Italy

Dec 01, 2007, 04:58:35 PM

I think you must use a WHERE clause in your query such as

update table set field = field + 'this is the string' WHERE field=value;

GaryGyjax

Junior Member

Joined: Oct 2007
Posts: 55

$View GaryGyjax\s Profile$

United States

Dec 01, 2007, 05:12:43 PM

thanks for the reply but I'm trying to update all records in my database that's why there is no WHERE in my statement.

Free Ringtones Sign Language Books

Code4Gold

Administrator

Joined: Jan 2006
Posts: 6215

Administrator

$View Code4Gold\s Profile$

United States

Dec 02, 2007, 03:09:29 AM

To concatenate a string in MySQL, you need to use the concat function....

update table set field = concat(field, 'this is the string')

The function is "overloaded" so you can concat as many values as you want to like this...

update table set field = concat(field, 'this is the string', 'string2', 'string3', string4')

Latest Blog Post : 8 Tips for Creating a Marketing Buzz

Best Affiliate Programs Ξ SocialNews Ξ Blogger Forum Ξ Wealth Watching

Summer Savings! $7.49 .com domains at GoDaddy.com!

Pages: [1]