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

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

--------------
DELETE FROM PUBACC_LO

  WHERE NOT (location_state='CA' OR location_state='')
--------------

Query OK, 1298045 rows affected (16.59 sec)

Bye