1UPDATE `tiki_tracker_fields` 2 SET `options`= CONCAT('1', RIGHT(`options`, CHAR_LENGTH(`options`) - 1)) 3WHERE 4 `type` IN ('t','n','b') AND 5 NOT ISNULL(`options`) AND 6 LEFT(`options`, 1) = '0'; 7