echo "select * from a where field1 REGEXP '$foo';" | /usr/bin/sqlite3 mydb.db
/usr/bin/sqlite3 mydb.db <<EOT select * from a where field1 REGEXP '$foo'; EOT 2012/1/5, Hajo Locke <[email protected]>: > Hello List, > > i use sqlite 3.6.22 Ubuntu 10.04 > > I want to use REGEXP in my queries but dont find a way to load the lib in > noninteractive Mode. > There is no -load Parameter for sqlite3 Binary. I tried to give 2 commands > separated by ; in sql-query but this also dont works. > All i want to do is to run a query on console like: > /usr/bin/sqlite3 mydb.db "select * from a where field1 REGEXP '$foo';" > > What to do now? > > Thanks, > Hajo > > _______________________________________________ > sqlite-users mailing list > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
