Sqlite3 to remove entries from database without a target IP?

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 so _gateway was and if I use that in the line above, it works as expected.

Solved by OP.

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