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

+-------------------------+
| version()               |
+-------------------------+
| 5.0.45-community-nt-log | 
+-------------------------+
1 row in set (0.01 sec)

--------------
DELETE FROM PUBACC_CP
  WHERE NOT (state_code='CA')
--------------

Query OK, 708315 rows affected (42.41 sec)

Bye