Sqlite3 to remove entries from database without a target IP?

Help Community Help
1

I have thousand of entries in my log corresponding to "_gateway" which does not show up with an IP address. I want to use sqlite3 to remove them from the database, but I am unsure the syntax since there is not an IP address.

I tried this which did not work:

sqlite3 /etc/pihole/pihole-FTL.db "DELETE from query_storage where client in (SELECT id from client_by_id where ip like '_gateway')"

EDIT: I see what to do now... my pi-hole runs in a linux container on 10.0.4.250 so _gateway was 10.0.4.1 and if I use that in the line above, it works as expected.

2

Solved by OP.

3

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.