Greetings.
I would like some help with this scenario... DB name OpenJobs.
id,pid,spid,notes
100, 24,32,'this is a test'
101, 24,32,'a different note'
102, 24,32,'yet, another different note'
...
What I dould like to do is to update each of those notes by adding a string
to the front of data contained in the notes. The final DB data would look
like this:
id,pid,spid,notes
100, 24,32,'string to add in front\r\nthis is a test'
101, 24,32,'string to add in front\r\na different note'
102, 24,32,'string to add in front\r\nyet, another different note'
...
I have come up with this:
UPDATE OpenJobs SET notes = 'string to add in front\r\n' ||
(SELECT notes from OpenJobs where spid = 32) WHERE spid = 32;
But I don't think it's going to work.
Any help would be greatly appreciated.
thanks.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
