--------------
SELECT version()
--------------

+------------------+
| version()        |
+------------------+
| 5.1.50-community |
+------------------+
1 row in set (0.00 sec)

--------------
DELETE FROM PUBACC_FR
  WHERE convert( PUBACC_FR.frequency_assigned, DECIMAL ) >= 1000
--------------

Query OK, 441886 rows affected (12.06 sec)

Bye