On 1 Sep 2011, at 12:37am, teahou wrote: > The closest I have come is to do it in parts, I came up with this: > > UPDATE questions SET answer = REPLACE(answer, '<a href=''/FAQ/', '<a > style="text-decoration: underline; color: blue" > onclick="Ti.App.fireEvent(''openContent'', {kind: ''FAQ'', find: "' ); > > As you can see, this just does the first part, and forces me to do each > category individually. > > I had thought to use a combination of substr/instr but the link locations > vary, it could be at the beginning of the text, or it could start after 100 > characters.
Do it in software. That's what programming languages are for. 10 seconds to take a backup copy of the database. 30 minutes to write the program and test it, 10 seconds to run it. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users