UPDATE `supplier` SET `supplierCode` = 'SUPP1', `supplierCompanyNo` = '1234-v-0088', `supplierName` = 'awan biru sdn bhd', `attention` = '', `line1` = 'jalan awan 1', `line2` = 'taman biru 2', `line3` = 'kg awan biru', `supplierPostCode` = '43000', `email` = '', `website` = '', `phoneNumber1` = '', `phoneNumber2` = '', `fax` = '', `generalNote` = '', `gstRegNo` = '', `termsID` = 0, `supplierCountryID` = '458', `supplierStateID` = '0', `linkedAPAccountID` = '258', `currencyID` = '2', `creditLimitAlert` = 0, `creditLimit` = '52,220.00', `termstatus` = '17', `createdDate` = '2014-08-01' WHERE `ID` =  '26'