UPDATE `nis`.`timesheets` SET `holiday` = '', `pto` = '8', `other` = '', `notes` = '' WHERE `timesheets`.`uid` ='1' and `timesheets`.`date` not REGEXP '.*(19|20)' and `timesheets`.`date` BETWEEN '2008/01/18' and '2008/01/22' LIMIT 45 # Affects 0 rows. # 2008/01/18 exists. # Perhaps a problem with my REGEXP ?