By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE mytable (
data1 int(11)
, data2 int(11)
)
;
INSERT INTO mytable (data1, data2)
VALUES (1072, -2046820062)
, (1072, 1056)
, (1041, 1056)
, (1041, 1056)
;
SELECT *
FROM mytable
;
DELETE FROM mytable
WHERE CAST(data2 AS SIGNED) < 0
;
SELECT *
FROM mytable
;
| data1 | data2 |
|---|---|
| 1072 | -2046820062 |
| 1072 | 1056 |
| 1041 | 1056 |
| 1041 | 1056 |
| data1 | data2 |
|---|---|
| 1072 | 1056 |
| 1041 | 1056 |
| 1041 | 1056 |