[thelist] [sql] append function?

[Paul Bennett]

Currently to append new data into a field I have to make 2 queries. One
(select) to get the existing data, php to append the new data to the end
of the old, and then another query (update) to put the new data in. I am
using text data and found that using:

$sql = "update $tableName set field = field + $newData where....";

doesn't work as I suspect it expects two numeric operators to perform
addition.
Is there anything like:
$sql = "update $tableName set field = APPEND($newData) where....";
I have googled,  searched a few favourite php haunts, and even the mysql
manual with no joy as yet...

--
Paul Bennett
Internet Developer
Teltest Electronic Design
--------------------------
Phone : 64 4 237 0767
Web : http://www.teltest.com
Wap : http://wap.teltest.com
Email : paul at teltest.com
--------------------------