[thelist] [mysql] concat problem [solved]

[Jay Blanchard]

[snip]
>update mytable set mycell = if(mycell IS NULL, concat(mycell,
>$formresults), $formresults) where id=1
>  
>
although the other way around, just to be completist about it... ; )

UPDATE mytable SET mycell = IF(mycell IS NULL, $formresults, 
CONCAT(mycell, $formresults) where id = 1
[/snip]

Right you are! OR.....

update mytable set mycell = if(mycell IS NOT NULL, concat(mycell,
$formresults), $formresults) where id=1