Page 1 of 1

Add onto field when UPDATE mysql

Posted: Wed Apr 12, 2006 7:02 pm
by Pineriver
Want to add onto a field at the end of the value in a mysql field.
In PHP if you wanted to add onto a string you would go :

$FieldList ='String';
$FieldList .=' Added Value';
print $FieldList;

Would return 'String Added Value', want to do the same thing when updating a row ..

Code: Select all

mysql_query("UPDATE `users` SET  'FieldList'=+'Added Value' WHERE ....
Something like that

Posted: Wed Apr 12, 2006 7:07 pm
by hawleyjr
This should point you in the right direction:

http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

Look for concat()