On Sun, Oct 10, 2010 at 11:05 PM, jose isaias cabrera <cabr...@wrc.xerox.com> wrote: > > 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; >
UPDATE OpenJobs SET notes = 'string to add in front\r\n' || notes 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 > -- Puneet Kishor http://www.punkish.org Carbon Model http://carbonmodel.org Charter Member, Open Source Geospatial Foundation http://www.osgeo.org Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor Nelson Institute, UW-Madison http://www.nelson.wisc.edu ----------------------------------------------------------------------- Assertions are politics; backing up assertions with evidence is science ======================================================================= _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users