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

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

--------------
DELETE FROM PUBACC_CP

  WHERE NOT (state_code='CA')
--------------

Query OK, 767617 rows affected (8.33 sec)

Bye