[thelist] [mysql] concat problem [solved]
Jay Blanchard
jay.blanchard at niicommunications.com
Wed Mar 30 10:01:18 CST 2005
[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
More information about the thelist
mailing list