On Thu, Dec 4, 2014 at 10:44 AM, Baruch Burstein <bmburst...@gmail.com> wrote: > > Is it possible to somehow search for/replace a string in all columns of all > tables? >
Not particularity the answer to your question, but rather a method you or others might use. I once implemented a virtual table "allvalues" that outputs all database values with (hope self-explaining) fields TableName, TableRowId, FieldName, Value that allows also exploring unknown complex databases. Take for example places.sqlite of Mozilla Firefox. If you want to explore where it saves your visited site, you can use the query SELECT Distinct TableName, FieldName FROM allvalues where Value like "%http://%"; Sqlite's virtual tables are a great tool since with a little effort on the developer side the newly created entity starts working as a first class citizen of the sqlite engine. Compare this to a quick hack that outputs all raw data from a specific database to a specific media. Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
