[thelist] [sql] append function?

[Paul Bennett]

shawn allen wrote:

>MySQL doesn't have a concatenation operator. Try the CONCAT() function:
>
$sql = "update $jobsTable set partsUsed = concat(partsUsed, '$newData')
where reference = '$id' limit 1";
works like a charm. Thanks :)
(I was doing all my searching for "mysql append" :p)

--
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
--------------------------