Please check the following query-
DELETE FROM or4_tbl_visitorips WHERE vdate!='2026-05-31'