This will remove any messages from your iMessage database that contain %File:% (% is a wildcard): sqlite3 ~/Library/Messages/chat.db "delete from message where

This will remove any messages from your iMessage database that contain %File:% (% is a wildcard): sqlite3 ~/Library/Messages/chat.db "delete from message where text like "%File:%"