Hi Baruch
I have a commercial tool that can do the search all tables bit but not
the replacing :) (not usually required by my clients - although I may
add it)
If you are a coder then it is a relatively straight forward process
along the lines of
Loop through each table
Loop through each column
UPDATE tablename SET colname = REPLACE(colname, 'oldtext', 'newtext')
The gotchas are how you choose to deal with strings stored in non text
fields and how unique your terms are/what you do with substrings
Paul
www.sandersonforensics.com
skype: r3scue193
twitter: @sandersonforens
Tel +44 (0)1326 572786
http://sandersonforensics.com/forum/content.php?195-SQLite-Forensic-Toolkit
-Forensic Toolkit for SQLite
http://sandersonforensics.com/forum/content.php?168-Reconnoitre - VSC
processing made easy
On 4 December 2014 at 08:10, Martin Engelschalk
<engelsch...@codeswift.com> wrote:
> Hi Baruch,
>
> no, not with SQL as I know it.
>
> Perhaps you can .dump and .output the database to a text file using sqlite3
> command shell, replace your text and then create the database from the SQL
> using .read.
>
> HTH
> Martin
>
> Am 04.12.2014 08:44, schrieb Baruch Burstein:
>>
>> Hi,
>>
>> Is it possible to somehow search for/replace a string in all columns of
>> all
>> tables?
>>
>> Thanks
>>
>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
