You can use DELETE to remove a record from a database table. Try:

DELETE FROM sightings WHERE sighting_id = 3;