This is my query:

UPDATE `methane`.`planning` SET `mz`=1 WHERE `import_date`='5/10/2011 12:00:00 AM' AND `lng`='-118.291' AND `lat`='34.0618';

import_date is a VARCAHR(1024);
mz is a BOOLEAN
lat & lng are FLOAT

If I go into MySQL Workbench and find that record it looks like this:

'248', '05/05/2011', 'ZA-2011-1137-ZV-ZAA-SPR', '3150 W WILSHIRE BLVD 90010', '10', 'Wilshire', 'CONTRUCTION OF A NEW MIX USED PROJECT INCLUDING 2 HIGH RISE TOWERS WITH GROUND FLOOR RETAIL PUBLIC 11860 OPEN SPACE AND 913 PARKING SPACES 464 APARTMENT UNITS 41000 SQ. FT. RETAIL SPACE.', 'ZV-ZONE VARIANCE ZAA-AREAHEIGHTYARDAND BUILDING LINE ADJMNTS < 20% (SLIGHT MODIFICATIONS) SPR-SITE PLAN REVIEW', 'KACY KEYS (323)857-5546', '5/10/2011 12:00:00 AM', '34.0618', '-118.291', NULL

THIS UPDATE WILL NOT UPDATE ANYTHING AT ALL. IT DOES NOT SET MZ TO 1 AND IT IS DRIVING ME MAD!!!!! PLEASE HELP!!!!