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

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

--------------
DELETE FROM PUBACC_LO
  WHERE NOT (location_state='CA' OR location_state='')
--------------

Query OK, 1158913 rows affected (1 min 59.36 sec)

Bye