[Typo3] Re: class.t3lib_db.php and CONCAT

[Jens Scheidtmann]

"JoH" <info at cybercraft.de> writes:

> Hi list.
> 

[...]

> I already got a solution to save the string directly with MySQL UPDATE and
> CONCAT.
> 
> UPDATE table SET field=CONCAT(field,',username:value');
> 

[...]

> Is this a special MySQL function that is not available for other DB?

Yes.

In Oracle you would write:

UPDATE table set field = field || ',username:value';

For more complex transactions (e.g. read out - modify - read back) 
you would use a cursor (resultset) ala:


SELECT field FROM table FOR UPDATE;
UPDATE table SET field = new_field_value;
COMMIT;

HTH,

Jens

-- 
Jens.Scheidtmann at bayerbbs.com