cutting a part of line till delimiter

here are the few scenarios...Code:isoSizeKB text NOT NULL, reserved1 varchar(255),      KEY `deviceId` (` ... http://bit.ly/tTXn89