> Dean Hamstead wrote:
>
> Is there a command to add to the end of a field when updating
> rather than overwriting it. Rather than extracting the current
> data, joining then updating the field?
PostgreSQL?
'string1' || 'string2' will concatenate for you. Outrageously confusing when
you're leaping from most languages to SQL.
Dunno about MySQL. :)
- Jeff
-- [EMAIL PROTECTED] ------------------------------- http://linux.conf.au/ --
Ye shall be cursed to fall in love so easily, and yet be so
cold of heart as never to express it.
--
SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/
More Info: http://slug.org.au/lists/listinfo/slug