Add something to a mysql string field
Posted: Tue May 17, 2005 5:18 pm
Lets say a field has the value White, but I want to add " dog" to it, how do I do that in a query?
A community of PHP developers offering assistance, advice, discussion, and friendship.
http://forums.devnetwork.net/
Code: Select all
var = "e;dog"e;;
mysql_query("e;update myTable set myField = concat(myField, '"e;.$var."e;') where id = $myid"e;)
or die(mysql_error());